Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
RecordsAffected Property
Collapse the table of content
Expand the table of content

IDataReader.RecordsAffected Property

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

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

int RecordsAffected { get; }

Property Value

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

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

IsClosed and RecordsAffected are the only properties that you can call after the IDataReader is closed.

.NET Framework

Supported in: 4.6, 4.5, 4, 3.5, 3.0, 2.0, 1.1

.NET Framework Client Profile

Supported in: 4, 3.5 SP1

XNA Framework

Supported in: 3.0, 2.0, 1.0
Show:
© 2015 Microsoft