OracleDataReader Class

Reads a forward-only stream of rows from an Oracle database.

For a list of all members of this type, see OracleDataReader members.

Inheritance Hierarchy

System.Object
   System.MarshalByRefObject
      System.Data.Common.DbDataReader
         Devart.Common.DbDataReaderBase
            Devart.Data.Oracle.OracleDataReader

Syntax

[Visual Basic]
Public Class OracleDataReader 
   Inherits DbDataReaderBase
   Implements IEnumerable, IDataReader, IDataRecord, IDisposable

[C#]
public class OracleDataReader : DbDataReaderBase, IEnumerable, IDataReader, IDataRecord, IDisposable

Remarks

To create a OracleDataReader, you must call the ExecuteReader method of the OracleCommand object, rather than directly using a constructor.

Devart.Common.DbDataReaderBase.IsClosed and RecordsAffected are the only properties that you can call after the OracleDataReader is closed. In some cases, you must call Close before you can call RecordsAffected.

Example

The following example creates a OracleConnection, a OracleCommand, and a OracleDataReader. The example reads through the data, writing it out to the console. Finally, the example closes the OracleDataReader, then the OracleConnection.

[C#]

public void ReadMyData(string myConnString)  
{ 
  string mySelectQuery = "SELECT DeptNo, DName FROM Test.Dept"; 
  OracleConnection myConnection = new OracleConnection(myConnString); 
  OracleCommand myCommand = new OracleCommand(mySelectQuery,myConnection); 
  myConnection.Open(); 
  try 
  { 
    OracleDataReader myReader = myCommand.ExecuteReader(); 
     
    // Always call Read before accessing data. 
    while (myReader.Read())  
    { 
      Console.WriteLine(myReader.GetInt32(0) + ", " + myReader.GetString(myReader.GetOrdinal("DName"))); 
    } 
 
    // always call Close when done reading. 
    myReader.Close(); 
 
    // Close the connection when done with it. 
    } 
  finally 
  { 
    myConnection.Close(); 
  } 
}

[Visual Basic]

Public Sub ReadMyData(ByVal myConnString As String)
   Dim mySelectQuery As String = "SELECT DeptNo, DName FROM Test.Dept"
   Dim myConnection As New OracleConnection(myConnString)
   Dim myCommand As New OracleCommand(mySelectQuery, myConnection)
   myConnection.Open()
   Try
     Dim myReader As OracleDataReader = myCommand.ExecuteReader()
 
    ' Always call Read before accessing data.
     While myReader.Read()
       Console.WriteLine(myReader.GetInt32(0).ToString() + ", " _
           + myReader.GetString(myReader.GetOrdinal("DName")))
     End While
     ' always call Close when done reading.
     myReader.Close()
 
    ' Close the connection when done with it.
   Finally
     myConnection.Close()
   End Try
 End Sub

See Also

Language