Close Method

Closes the OracleDataReader object.

[Visual Basic]
Overrides Public Sub Close()

[C#]
public override void Close();

Remarks

You must explicitly call the Close method when you are finished using the OracleDataReader to use the associated OracleConnection for any other purpose.

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(); 
  OracleDataReader myReader; 
  myReader = myCommand.ExecuteReader(); 
  // Always call Read before accessing data. 
  while (myReader.Read()) { 
    Console.WriteLine(myReader.GetInt32(0) + ", " + myReader.GetString(1)); 
  } 
  // always call Close when done reading. 
  myReader.Close(); 
  // Close the connection when done with it. 
  myConnection.Close(); 
}

[Visual Basic]

Public Sub ReadMyData(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()
   Dim myReader As OracleDataReader
   myReader = myCommand.ExecuteReader()
   ' Always call Read before accessing data.
   While myReader.Read()
     Console.WriteLine(myReader.GetInt32(0).ToString() + ", " _
       + myReader.GetString(1))
   End While
   ' always call Close when done reading.
   myReader.Close()
   ' Close the connection when done with it.
   myConnection.Close()
 End Sub

See Also

Language

Close Method

Remarks

Example

See Also