Returns a DataSet for the supplied QueryCommandConfig

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

Syntax

C#
public DataSet GetDataSet(
	QueryCommandConfig CmdConfig
)
Visual Basic (Declaration)
Public Function GetDataSet ( _
	CmdConfig As QueryCommandConfig _
) As DataSet
Visual C++
public:
DataSet^ GetDataSet(
	QueryCommandConfig^ CmdConfig
)

Parameters

CmdConfig
Type: DbNetLink.Data..::.QueryCommandConfig

Combined parameterised sql statement/procedure and parameter values

Return Value

A DataSet

Examples

CopyC#
DbNetData Db = new DbNetData( ConfigurationManager.ConnectionStrings["nwind"] );
Db.Open();
QueryCommandConfig CmdConfig = new QueryCommandConfig("select * from products");
CmdConfig.Params["categoryid"] = CategoryID.Value;
DataGrid1.DataSource = Db.GetDataSet(CmdConfig);
DataGrid1.DataBind();
Db.Close();

See Also