SqlDataSourceStatusEventArgs.AffectedRows Property

Definition

Namespace:

System.Web.UI.WebControls

Assembly:

System.Web.dll

Gets the number of rows affected by a database operation.

public:
 property int AffectedRows { int get(); };

public int AffectedRows { get; }

member this.AffectedRows : int

Public ReadOnly Property AffectedRows As Integer

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.

See also

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