Executes a select statement or stored procedure that returns a record set. Uses the CommandConfig argument to encapsulate the command text, parameter values and command behavior.

Namespace:  DbNetLink.Data
Assembly:  DbNetLink.DbNetData (in DbNetLink.DbNetData.dll) Version: 1.0.0.0 (1.0.0.0)

Syntax

C#
public void ExecuteQuery(
	QueryCommandConfig CmdConfig
)
Visual Basic (Declaration)
Public Sub ExecuteQuery ( _
	CmdConfig As QueryCommandConfig _
)
Visual C++
public:
void ExecuteQuery(
	QueryCommandConfig^ CmdConfig
)

Parameters

CmdConfig
Type: DbNetLink.Data..::.QueryCommandConfig

The SQL statement, parameters and command behavior

Examples

CopyC#
DbNetData Db = new DbNetData( ConfigurationManager.ConnectionStrings["nwind"] );
Db.Open();
QueryCommandConfig CmdConfig = new QueryCommandConfig("select * products");
CmdConfig.Params["discontinued"] = 1;
CmdConfig.Behavior = CommandBehavior.SequentialAccess;
Db.ExecuteQuery(CmdConfig)
DiscontinuedProductsGridView.DataSource = Db.Reader;   
DiscontinuedProductsGridView.DataBind(); 
Db.Close();

See Also