'Declaration
 
Public Overloads Shared Function ExecuteDataSet( _
   ByVal connection As IDbConnection, _
   ByVal commandType As CommandType, _
   ByVal commandText As String _
) As DataSet

public static DataSet ExecuteDataSet( 
   IDbConnection connection,
   CommandType commandType,
   string commandText
)

Parameters

connection

A configured connection to the database

commandType

The CommandType to use when executing the commandText statement.

commandText

The text command to execute. The default value is an empty string ("").

Return Value

The connection parameter is not required to be an open connection. If it is not open when passed to this method, it will be opened and will be closed when the method is finished. If it is passed in open, or live, it will remain open when this method completes.

Not all providers return a DataSet with the same structure if no results are returned by the query. Some providers return an empty DataSet. Some providers return a DataSet with a single DataTable which contains zero rows. Test for tables and rows using the Count property on the DataSet and any DataTables before assuming any Tables or Rows exist. 

In no case will the DataSet returned be a null reference (Nothing in Visual Basic).

When the commandType parameter is set to StoredProcedure, set the commandText parameter to the name of the stored procedure. The user may be required to use escape character syntax if the stored procedure name contains any special characters. The command will call this stored procedure when you call one of the Execute methods.

Reference

SqlHelper Class
SqlHelper Members
Overload List