RecordsAffected property

Returns the number of rows changed, inserted, or deleted by the execution of the SQL statement. For SELECT statements this value is -1.

Syntax
Visual Basic
Public Readonly Property RecordsAffected As Integer
C#
public int RecordsAffected { get;}
Property value

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

See also