SqlHelper.ExecuteDataset Method (SqlTransaction, CommandType, String)

Execute a SqlCommand (that returns a resultset and takes no parameters) against the provided SqlTransaction.

[Visual Basic]
Overloads Public Shared Function ExecuteDataset( _
   ByVal transaction As SqlTransaction, _
   ByVal commandType As CommandType, _
   ByVal commandText As String _
) As DataSet

[C#]
public static DataSet ExecuteDataset(
   SqlTransaction transaction,
   CommandType commandType,
   string commandText
);

Parameters

transaction: a valid SqlTransaction
commandType: the CommandType (stored procedure, text, etc.)
commandText: the stored procedure name or T-SQL command

Return Value

a dataset containing the resultset generated by the command

Remarks

e.g.: DataSet ds = ExecuteDataset(trans, CommandType.StoredProcedure, "GetOrders");

SqlHelper.ExecuteDataset Method (SqlTransaction, CommandType, String)

Parameters

Return Value

Remarks

See Also