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

AdsCommand.ExecuteReader( CommandBehavior )

Advantage .NET Data Provider

Previous pageReturn to chapter overviewNext page

Executes the AdsCommand.CommandText and returns an AdsDataReader with the result set based on the CommandBehavior value.

public AdsDataReader ExecuteReader( CommandBehavior behavior );

Remarks

Depending on the CommandBehavior value, this executes the SQL statement or stored procedure or opens the table that is specified in the AdsCommand.CommandText property.

The CommandBehavior values that affect the AdsDataReader are shown in the following table. Bitwise combinations of these values can be used.

Member name

Description

CloseConnection

When the command is executed, the associated Connection object is closed when the associated DataReader object is closed.

Default

Default sets no CommandBehavior flags, so calling ExecuteReader(CommandBehavior.Default) is functionally equivalent to calling ExecuteReader().

KeyInfo

The query returns column and primary key information.

SchemaOnly

The query returns column information only. No result set is returned.

SingleRow

The query is expected to return a single row. The Advantage .NET Data Provider will return multiple rows if requested by Read operations, but it will not be as efficient because the provider will use a smaller read cache size when this option is specified.

Example

This example executes the reader with the SchemaOnly bit set.

// create a connection object

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

AdsCommand cmd;

AdsDataReader reader;

 

try

{

 

// make the connection to the server

conn.Open();

 

// create a command object

cmd = conn.CreateCommand();

 

// specify a table name

cmd.CommandText = "departments";

cmd.CommandType = CommandType.TableDirect;

 

// get the schema for the table

reader = cmd.ExecuteReader( CommandBehavior.SchemaOnly );

 

// get the schema table itself

DataTable datatable = reader.GetSchemaTable();

 

// print some schema information

foreach ( DataRow row in datatable.Rows )

{

Console.Write( row["ColumnName"] );

Console.Write( "\t" + row["DataType"].ToString() );

Console.WriteLine( "\t" + row["IsKey"].ToString() );

}

 

conn.Close();

See Also

ExecuteReader

ExecuteScalar

ExecuteNonQuery

CommandText

AdsDataReader.GetSchemaTable

AdsExtendedReader