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:
property int AffectedRows {
	int 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.

No code example is currently available or this language may not be supported.

.NET Framework

Supported in: 4, 3.5

Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

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