Gets the number of rows changed, inserted, or deleted by execution of the Transact-SQL statement.
abstract RecordsAffected : int with get
override RecordsAffected : int with get
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. Implements IDataReader .RecordsAffected
property is not set until all rows are read and you close the RecordsAffected . SqlDataReader
The value of this property is cumulative. For example, if two records are inserted in batch mode, the value of
will be two. RecordsAffected and IsClosed are the only properties that you can call after the RecordsAffected is closed. SqlDataReader .NET Framework
Supported in: 4.5.2, 4.5.1, 4.5, 4, 3.5, 3.0, 2.0, 1.1, 1.0
.NET Framework Client Profile
Supported in: 4, 3.5 SP1
Windows 8.1, Windows Server 2012 R2, Windows 8, Windows Server 2012, Windows 7, Windows Vista SP2, Windows Server 2008 (Server Core Role not supported), Windows Server 2008 R2 (Server Core Role supported with SP1 or later; Itanium not supported)
The .NET Framework does not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.