Returns a DataSet for the supplied QueryCommandConfig
Declaration Syntax| C# | Visual Basic |
public DataSet GetDataSet( QueryCommandConfig CmdConfig )
Public Function GetDataSet ( _ CmdConfig As QueryCommandConfig _ ) As DataSet
Parameters- CmdConfig (QueryCommandConfig)
-
Combined parameterised sql statement/procedure and parameter values
Return Value
A DataSet
Examples
CopyC#DbNetData Data = new DbNetData( ConfigurationSettings.AppSettings[ "nwind" ] ); Data.Open(); QueryCommandConfig CmdConfig = new QueryCommandConfig("select * from products"); CmdConfig.Params["categoryid"] = CategoryID.Value; DataGrid1.DataSource = Data.GetDataSet(CmdConfig); DataGrid1.DataBind(); Data.Close();