Dotnet-Project Framework documentation.

GenericDataHelper.ExecuteDataSetTransactional Method (String, IDataParameter[])

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

public static DataSet ExecuteDataSetTransactional(
   string spName,
   params IDataParameter[] commandParameters
);

Parameters

spName
The stored procedure name or T-SQL command
commandParameters
An array of Paramters used to execute the command

Return Value

A dataset containing the resultset generated by the command

Example

DataSet ds = ExecuteDataset("GetOrders", new SqlParameter("@prodid", 24));

See Also

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