RecordsAffected Property

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

Syntax

int RecordsAffected

Access

Read-only

Property Value

The number of rows changed, inserted, or deleted. This is 0 if no rows were affected or the statement failed, or -1 for Select statements.

Implements

IDataReader.RecordsAffected

Usage

  • The number of rows changed, inserted, or deleted. The value is 0 if no rows were affected or the statement failed, and -1 for Select statements.

  • The value of this property is cumulative. For example, if two records are inserted in batch mode, the value of RecordsAffected will be two.

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

Parent topic: AseDataReader Class