Export (0) Print
Expand All

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.";
    }
    else
      Message.Text = "An exception occurred inserting the new Contact. " +
        "Please verify the values in the newly inserted item.";

    e.ExceptionHandled = true;
  }
}

.NET Framework

Supported in: 4.6, 4.5, 4, 3.5

Windows 8.1, Windows Server 2012 R2, Windows 8, Windows Server 2012, Windows 7, Windows Vista SP2, Windows Server 2008 (Server Core Role not supported), Windows Server 2008 R2 (Server Core Role supported with SP1 or later; Itanium not supported)

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

Show:
© 2014 Microsoft