Derives the parameters for a stored procedure
Declaration Syntax| C# | Visual Basic |
public ListDictionary DeriveParameters( string ProcedureName )
Public Function DeriveParameters ( _ ProcedureName As String _ ) As ListDictionary
Parameters- ProcedureName (String)
-
The name of the stored procedure
Return Value
Returns a collection of IDbDataParameter objects for each parameter in the stored procedure
Examples
CopyC#DbNetData Data = new DbNetData( ConfigurationSettings.AppSettings[ "nwind" ] ); Data.Open(); ListDictionary Params = Data.DeriveParameters("CustOrderHist"); ((IDbDataParameter)Params["customerid"]).Value = Customers.SelectedValue; Data.ExecuteQuery( "CustOrderHist", Params ); ResultsGridView.DataSource = Data.Reader; ResultsGridView.DataBind(); Data.Close();