Parses the Sql statement for parameter names and returns a corresponding paramater collection

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

Syntax

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

Parameters

Sql
Type: System..::.String

The SQL statement

Return Value

Returns a collection of parameter objects for each parameter in the SQL

Examples

CopyC#
DbNetData Db = new DbNetData( ConfigurationManager.ConnectionStrings["nwind"] );
Db.Open();
string Sql = "select first_name from user where userid = @userid";
ListDictionary Params = Data.ParseParameters(Sql);
Params["userid"] = Users.SelectedValue;
Db.ExecuteQuery( Sql, Params );
Db.Close();

See Also