ExecuteDataSet() Method
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
Syntax
'Declaration
Public Overloads Function ExecuteDataSet() As DataSet
public DataSet ExecuteDataSet()
Return Value
A DataSet with zero or more DataTable objects each containing zero or more rows.
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