Sets the value of a parameter in a collection irrespective of case-sensitivity and whether the parameter is a simple
value or IDbDataParameter object
Declaration Syntax| C# | Visual Basic |
public void SetParamValue( ListDictionary Params, string ParamName, Object ParamValue )
Public Sub SetParamValue ( _ Params As ListDictionary, _ ParamName As String, _ ParamValue As Object _ )
Parameters- Params (ListDictionary)
-
The parameter collection
- ParamName (String)
-
The name of the parameter
- ParamValue (Object)
-
The parameter value to assign
Examples
CopyC#DbNetData Data = new DbNetData( ConfigurationSettings.AppSettings[ "nwind" ] ); Data.Open(); ListDictionary Params = Data.DeriveParameters("CustOrderHist"); Data.SetParamValue( Params, "customerid", Customers.SelectedValue ); Data.ExecuteQuery( "CustOrderHist", Params ); ResultsGridView.DataSource = Data.Reader; ResultsGridView.DataBind(); Data.Close();