dotConnect for Oracle Documentation
Devart.Data.Oracle Namespace / OracleCommand Class / ExecuteReader Method / ExecuteReader() Method
Example

On this page
    ExecuteReader() Method
    On this page
    Sends the CommandText to the Connection and builds a OracleDataReader.
    Syntax
    'Declaration
     
    Public Overloads Shadows Function ExecuteReader() As OracleDataReader
    public new OracleDataReader ExecuteReader()

    Return Value

    Example
    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.
    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();
      try
      {
        while(oracleReader.Read())
        {
          Console.WriteLine(oracleReader.GetString(0));
        }
      }
      finally
      {
        oracleReader.Close();
        oracleConnection.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()
      Try
        While oracleReader.Read()
          Console.WriteLine(oracleReader.GetString(0))
        End While
      Finally
        oracleReader.Close()
        oracleConnection.Close()
      End Try
    End Sub
    See Also