AdsCommand.ExecuteReader

Executes the AdsCommand.CommandText and returns an AdsDataReader with the result set.

public AdsDataReader ExecuteReader();

Remarks

ExecuteReader executes the SQL statement or stored procedure or opens the table that is specified in the AdsCommand.CommandText property.

Example

// create a connection object

AdsConnection conn = new AdsConnection( "data source=c:\\data;" );

AdsCommand cmd;

AdsDataReader reader;

int iField;

try

{

// make the connection to the server

conn.Open();

// create a command object

cmd = conn.CreateCommand();

// specify a simple SELECT statement

cmd.CommandText = "select * from departments";

// execute the statement and create a reader

reader = cmd.ExecuteReader();

// dump the results of the query to the console

while ( reader.Read() )

{

for ( iField = 0; iField < reader.FieldCount; iField++ )

Console.Write( reader.GetValue(iField) + " ");

Console.WriteLine();

}

// close the reader (can’t execute other statements

// on this command or connection) until it is closed

reader.Close();

conn.Close();

}

catch ( AdsException e )

{

// print the exception message

Console.WriteLine( e.Message );

}