Dotnet-Project Framework documentation.

GenericDataHelper.FillDatasetTransactional Method (String, DataSet, String[], IDataParameter[])

Execute a stored procedure via a Command (that returns a resultset) against a Transaction using the provided parameters.

public static void FillDatasetTransactional(
   string spName,
   DataSet dataSet,
   string[] tableNames,
   params IDataParameter[] commandParameters
);

Parameters

spName
The stored procedure name
dataSet
A dataset wich will contain the resultset generated by the command
tableNames
This array will be used to create table mappings allowing the DataTables to be referenced by a user defined name (probably the actual table name)
commandParameters
An array of Paramters used to execute the command

Example

FillDataset("GetOrders", ds, new string[] {"orders"}, new SqlParameter("@prodid", 24));

See Also

GenericDataHelper Class | DotnetProject.Data Namespace | GenericDataHelper.FillDatasetTransactional Overload List