Returns a DataSet for the supplied SQL statement and parameter values

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

Syntax

C#
public DataSet GetDataSet(
	string Sql,
	IDictionary Params
)
Visual Basic (Declaration)
Public Function GetDataSet ( _
	Sql As String, _
	Params As IDictionary _
) As DataSet
Visual C++
public:
DataSet^ GetDataSet(
	String^ Sql, 
	IDictionary^ Params
)

Parameters

Sql
Type: System..::.String

SQL statement or stored procedure name

Params
Type: System.Collections..::.IDictionary

Parameter values collection

Return Value

A DataSet

Examples

CopyC#
DbNetData Db = new DbNetData( ConfigurationSettings.AppSettings["nwind"] );
Db.Open();
ListDictionary Params = new ListDictionary();
Params["categoryid"] = CategoryID.Value;
DataGrid1.DataSource = Db.GetDataSet("select * from products", Params);
DataGrid1.DataBind();
Db.Close();

See Also