DbDataReader::RecordsAffected Property

.NET Framework (current version)

Gets the number of rows changed, inserted, or deleted by execution of the SQL statement.

Namespace: System.Data.Common
Assembly: System.Data (in System.Data.dll)

Syntax

public:
property int RecordsAffected {
	virtual int get() abstract;
}

Type: System::Int32

The number of rows changed, inserted, or deleted. -1 for SELECT statements; 0 if no rows were affected or the statement failed.

The RecordsAffected property is not set until all rows are read and you close the DataReader.

This property and IsClosed should be implemented to return a value when the reader is closed.

Universal Windows Platform
Available since 10
.NET Framework
Available since 2.0