Executes a parameterised select statement or stored procedure with a specified 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(
	string Sql,
	IDictionary Params,
	CommandBehavior Behaviour
)
Visual Basic (Declaration)
Public Sub ExecuteQuery ( _
	Sql As String, _
	Params As IDictionary, _
	Behaviour As CommandBehavior _
)
Visual C++
public:
void ExecuteQuery(
	String^ Sql, 
	IDictionary^ Params, 
	CommandBehavior Behaviour
)

Parameters

Sql
Type: System..::.String

The SQL statement

Params
Type: System.Collections..::.IDictionary

Parameter values collection

Behaviour
Type: System.Data..::.CommandBehavior

CommandBehavior

Examples

CopyC#
DbNetData Db = new DbNetData( ConfigurationManager.ConnectionStrings["nwind"] );
Db.Open();
ListDicitonary Params = new ListDicitonary();
Params["discontinued"] = 0;
Db.ExecuteQuery("select * from products where discontinued <> @discontinued")
DiscontinuedProductsGridView.DataSource = Db.Reader;   
DiscontinuedProductsGridView.DataBind(); 
Db.Close();

See Also