GetDataSet()

Use the GetDataSet() method to retrieve the dataset stored in memory that was generated when the command object finished processing.

Syntax

DataSet GetDataset( )

Remarks

It is not recommended that you use this method under normal conditions, because the actual dataset may contain large amount of data (huge number of rows). This method is provided for advanced users that want to directly use the SQLClient namespace to interact with the dataset.

Note: If you execute this method in a synchronous script with a large number of rows, the script may time out. If you plan to use this method, it is recommended that you configure the script to run asynchronously.

ArchestrA QuickScript uses 1-based indexing when square-bracket notation is used with numeric indexes, such as DataSet.Tables[7].

To avoid confusion, use square-bracket notation with collections that support strong name indexing, such as DataSet.Tables["Customers"]. You can also bypass the dataset object by using the wrapping accessor functions described in the next sections.