 |  | Devart.Data.Oracle | Send comments on this topic. |
| Devart.Data.Oracle Namespace > OracleCommand Class > ExecuteReader Method : ExecuteReader() Method |
| | Devart.Data.Oracle | Send comments on this topic. |
| Devart.Data.Oracle Namespace > OracleCommand Class > ExecuteReader Method : ExecuteReader() Method |
Sends the CommandText to the Connection and builds a OracleDataReader.
[Visual Basic]
Overloads Public Function ExecuteReader() As OracleDataReader[C#]
public OracleDataReader ExecuteReader();A OracleDataReader object.
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 database.
[C#]
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();
try
{
while(myReader.Read())
{
Console.WriteLine(myReader.GetString(0));
}
}
finally
{
myReader.Close();
myConnection.Close();
}
} [Visual Basic]
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()
Try
While myReader.Read()
Console.WriteLine(myReader.GetString(0))
End While
Finally
myReader.Close()
myConnection.Close()
End Try
End SubOracleCommand Class | OracleCommand Members | Overload List | OracleDataReader Class | OracleConnection Class
© 2002 - 2013 Devart. All Rights Reserved.