Parses the Sql statement for parameter names and returns a corresponding paramater collection
Declaration Syntax| C# | Visual Basic |
public ListDictionary ParseParameters( string Sql )
Public Function ParseParameters ( _ Sql As String _ ) As ListDictionary
Parameters- Sql (String)
-
The SQL statement
Return Value
Returns a collection of parameter objects for each parameter in the SQL
Examples
CopyC#DbNetData Data = new DbNetData( ConfigurationSettings.AppSettings[ "nwind" ] ); Data.Open(); string Sql = "select first_name from user where userid = @userid"; ListDictionary Params = Data.ParseParameters(Sql); Params["userid"] = Users.SelectedValue; Data.ExecuteQuery( Sql, Params ); Data.Close();