ExecuteDataSet Method
Overload List
| Overload | Description |
|---|---|
| ExecuteDataSet() | Executes the the SQL specified in the CommandText Property against the database using the provider specified in the DataProvider Property and returns the results as a DataSet |
| ExecuteDataSet(String) | Executes the the specified SQL using the default DbProvider and returns the results as a DataSet |
| ExecuteDataSet(CommandType,String) | Executes the the specified SQL against the database using the default DbProvider and returns the results as a DataSet |
| ExecuteDataSet(CommandType,String,DataParameterCollection) | Executes the the specified parameterized SQL command with the specified parameters against the database using the default DbProvider and returns the results as a DataSet |
| ExecuteDataSet(IDbConnection,CommandType,String) | Executes the the specified SQL using the provided database connection and returns the results as a DataSet |
| ExecuteDataSet(IDbConnection,CommandType,String,DataParameterCollection) | Executes the the specified parameterized SQL with the specified parameters using the provided database connection and returns the results as a DataSet |
| ExecuteDataSet(IDbTransaction,CommandType,String) | Executes the the specified SQL using the provided database transaction and returns the results as a DataSet |
| ExecuteDataSet(IDbTransaction,CommandType,String,DataParameterCollection) | Executes the the specified SQL with the specified parameters using the provided database transaction and returns the results as a DataSet |
Remarks
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).
Requirements
Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server family