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 oracleConnectionString)
{
OracleConnection oracleConnection = new OracleConnection(oracleConnectionString);
OracleCommand oracleCommand = new OracleCommand(mySelectQuery, oracleConnection);
oracleCommand.Connection.Open();
OracleDataReader oracleReader = oracleCommand.ExecuteReader(CommandBehavior.CloseConnection);
while(oracleReader.Read())
{
Console.WriteLine(oracleReader.GetString(0));
}
oracleReader.Close();
} |
|
|---|
Public Sub CreateOracleDataReader(mySelectQuery As String, _
oracleConnectionString As String)
Dim oracleConnection As New OracleConnection(oracleConnectionString)
Dim oracleCommand As New OracleCommand(mySelectQuery, oracleConnection)
oracleCommand.Connection.Open()
Dim oracleReader As OracleDataReader = oracleCommand.ExecuteReader(CommandBehavior.CloseConnection)
While oracleReader.Read()
Console.WriteLine(oracleReader.GetString(0))
End While
oracleReader.Close()
End Sub |