This topic has not yet been rated - Rate this topic

OracleDataReader.RecordsAffected Property

.NET Framework 4.5

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

Namespace: System.Data.OracleClient
Assembly: System.Data.OracleClient (in System.Data.OracleClient.dll)

abstract RecordsAffected : int with get 
override RecordsAffected : int with get

Property Value

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

Implements

IDataReader.RecordsAffected

Remarks

The RecordsAffected property is not set until all rows are read and you close the OracleDataReader.

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

Version Information

.NET Framework

Supported in: 4.5, 4, 3.5, 3.0, 2.0, 1.1

Platforms

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.

Reference

OracleDataReader Class

System.Data.OracleClient Namespace

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)