SqlDataSourceStatusEventArgs.AffectedRows Property

Definition

Namespace:

System.Web.UI.WebControls

Assembly:

System.Web.dll

Gets the number of rows affected by a database operation.

C#

public int AffectedRows { get; }

Property Value

Int32

The number of rows affected by a database operation. The default value is -1.

Remarks

All operations return the number of rows affected by the operation. The AffectedRows property has the same value as the return value of the Update, Insert, and Delete methods.

When the Select method is called and the data source is set to DataReader mode, the return value is 0 in all cases.

Applies to

See also

• Update()
• Insert()
• Delete()