ExecuteReader(CommandBehavior) Method
The following example creates a
OracleCommand, then executes it by passing a string that is SQL SELECT statement, and a string to use to connect to the data source. The
System.Data.CommandBehavior is then set to CloseConnection.
public void CreateOracleDataReader(string mySelectQuery,string myConnectionString)
{
OracleConnection myConnection = new OracleConnection(myConnectionString);
OracleCommand myCommand = new OracleCommand(mySelectQuery, myConnection);
myCommand.Connection.Open();
OracleDataReader myReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
while(myReader.Read())
{
Console.WriteLine(myReader.GetString(0));
}
myReader.Close();
}
Public Sub CreateOracleDataReader(mySelectQuery As String, _
myConnectionString As String)
Dim myConnection As New OracleConnection(myConnectionString)
Dim myCommand As New OracleCommand(mySelectQuery, myConnection)
myCommand.Connection.Open()
Dim myReader As OracleDataReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection)
While myReader.Read()
Console.WriteLine(myReader.GetString(0))
End While
myReader.Close()
End Sub