Derives the parameters for a stored procedure

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

Syntax

C#
public ListDictionary DeriveParameters(
	string ProcedureName
)
Visual Basic (Declaration)
Public Function DeriveParameters ( _
	ProcedureName As String _
) As ListDictionary
Visual C++
public:
ListDictionary^ DeriveParameters(
	String^ ProcedureName
)

Parameters

ProcedureName
Type: System..::.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 Db = new DbNetData( ConfigurationManager.ConnectionStrings["nwind"] );
Db.Open();
ListDictionary Params = Db.DeriveParameters("CustOrderHist");
((IDbDataParameter)Params["customerid"]).Value = Customers.SelectedValue;
Db.ExecuteQuery( "CustOrderHist", Params );
ResultsGridView.DataSource = Db.Reader;
ResultsGridView.DataBind();
Db.Close();

See Also