RecordsAffected property

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

Visual Basic syntax

Public ReadOnly Shadows Property RecordsAffected As Integer

C# syntax

public new int RecordsAffected {get;}

Remarks

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