Returns the number of rows changed, inserted, or deleted by execution of the SQL statement. For SELECT statements or CommandType.TableDirect tables, this value is -1.
Visual Basic
NotOverridable Public Readonly Property RecordsAffected As Integer _
Implements IDataReader.RecordsAffected
C#
public int RecordsAffected {get;}
The number of rows changed, inserted, or deleted by execution of the SQL statement.