Navigation:  Advantage .NET Data Provider > AdsCommand Class > AdsCommand Methods >

AdsCommand.ExecuteReader

Advantage .NET Data Provider

Previous pageReturn to chapter overviewNext page

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 );

}

See Also

ExecuteReader( CommandBehavior )

CommandText

AdsDataReader

AdsExtendedReader