RecordsAffected Property
Collapse the table of content
Expand the table of content

DbDataReader::RecordsAffected Property

 

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)

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

Property Value

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.

Notes to Inheritors:

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
Return to top
Show:
© 2016 Microsoft