This documentation is archived and is not being maintained.

ListViewInsertedEventArgs.AffectedRows Property

Gets the number of rows affected by the insert operation.

Namespace:  System.Web.UI.WebControls
Assembly:  System.Web.Extensions (in System.Web.Extensions.dll)

public int AffectedRows { get; }

Property Value

Type: System.Int32
The number of rows affected by the insert operation.

Use the AffectedRows property to determine the number of records that were affected by the insert operation, as returned by the data source control. This property is typically used in the following scenarios:

  • To verify that only a single record was inserted. Sometimes an incorrectly written insert statement can insert multiple records.

  • To verify that a record was not inserted because an error occurred during the insert operation, but an exception was not raised.

  • To verify that a record was inserted when a data source control that supports conflict detection (optimistic concurrency) has its ConflictDetection property set to the ConflictOptions.CompareAllValues enumeration value. Controls that supports this property include the SqlDataSource and ObjectDataSource controls. When the property has this value, a record might not be inserted if it has the same key value as a record inserted by another user.

The following example shows how to use the ListViewInsertedEventArgs object that is passed to a handler for the ItemInserted event to determine whether an exception was raised during the insert operation. This code example is part of a larger example provided for the ListViewInsertedEventArgs class.

void ContactsListView_ItemInserted(Object sender, ListViewInsertedEventArgs e)
  if (e.Exception != null)
    if (e.AffectedRows == 0)
      e.KeepInInsertMode = true;
      Message.Text = "An exception occurred inserting the new Contact. " +
        "Please verify your values and try again.";
      Message.Text = "An exception occurred inserting the new Contact. " +
        "Please verify the values in the newly inserted item.";

    e.ExceptionHandled = true;

Windows 7, Windows Vista, Windows XP SP2, Windows Server 2008 R2, Windows Server 2008, Windows Server 2003

The .NET Framework and .NET Compact Framework do not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.

.NET Framework

Supported in: 3.5