DADataAdapter.Fill

Adds or refreshes rows in System.Data.DataSet to match those in TDataSet and creates DataTable.

Unit

Syntax

Remarks

Adds or refreshes rows in System.Data.DataSet to match those in TDataSet using the DataSet parameter, and creates DataTable named tableName. Function returns the number of rows successfully inserted into DataSet.

The TDataSet object associated with DADataAdapter must be valid, but it does not need to be opened. If TDataSet is closed before Fill is called, it is opened to retrieve data, then closed. If TDataSet is opened before Fill is called, it remains opened.

If an error is encountered while populating a dataset, rows added prior to the occurrence of the error remain in the dataset. The remainder of the operation is aborted.

If TDataSet does not return any rows, fields are created and no rows are added to DataSet, and no exception is raised.

See Also

• Update