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