Represents a SQL statement, PL/SQL statement, or stored procedure to execute against Oracle.
The following example uses the
ExecuteReader method of
OracleCommand, along with
OracleDataReader and
OracleConnection, to select rows from a table.
|
|---|
public void ReadMyData(string myConnString)
{
string mySelectQuery = "SELECT DeptNo, DName FROM Test.Dept";
OracleConnection oracleConnection = new OracleConnection(myConnString);
OracleCommand oracleCommand = new OracleCommand(mySelectQuery,oracleConnection);
oracleConnection.Open();
OracleDataReader oracleReader = oracleCommand.ExecuteReader();
try
{
while (oracleReader.Read())
{
Console.WriteLine(oracleReader.GetInt32(0).ToString() + ", " + oracleReader.GetString(1));
}
}
finally
{
// always call Close when done reading.
oracleReader.Close();
// always call Close when done reading.
oracleConnection.Close();
}
} |
|
|---|
Public Sub ReadMyData(myConnString As String)
Dim mySelectQuery As String = "SELECT DeptNo, DName FROM Test.Dept"
Dim oracleConnection As New OracleConnection(myConnString)
Dim oracleCommand As New OracleCommand(mySelectQuery, oracleConnection)
oracleConnection.Open()
Dim oracleReader As OracleDataReader = oracleCommand.ExecuteReader()
Try
While oracleReader.Read()
Console.WriteLine(oracleReader.GetInt32(0).ToString() + ", " _
+ oracleReader.GetString(1))
End While
Finally
' always call Close when done reading.
oracleReader.Close()
' always call Close when done with connection.
oracleConnection.Close()
End Try
End Sub |