Executes a parameterised select statement or stored procedure with a specified command behavior
Declaration Syntax| C# | Visual Basic |
public void ExecuteQuery( string Sql, IDictionary Params, CommandBehavior Behaviour )
Public Sub ExecuteQuery ( _ Sql As String, _ Params As IDictionary, _ Behaviour As CommandBehavior _ )
Parameters- Sql (String)
-
The SQL statement
- Params (IDictionary)
-
Parameter values collection
- Behaviour (CommandBehavior)
-
CommandBehavior
Examples
CopyC#DbNetData Data = new DbNetData( ConfigurationSettings.AppSettings[ "nwind" ] ); Data.Open(); ListDicitonary Params = new ListDicitonary(); Params["discontinued"] = 0; Data.ExecuteQuery("select * from products where discontinued <> @discontinued") DiscontinuedProductsGridView.DataSource = Data.Reader; DiscontinuedProductsGridView.DataBind(); Data.Close();