Adds or refreshes rows in a DataSet or DataTable object with data from the database.
int Fill( DataSet dataSet )
int Fill( DataSet dataSet, string srcTable )
int Fill( DataSet dataSet, int startRecord, int maxRecords, string srcTable )
int Fill( DataTable dataTable )
dataSet: A DataSet to fill with records and, optionally, schema.
srcTable: The name of the source table to use for table mapping.
startRecord: The zero-based record number to start with.
maxRecords: The maximum number of records to be read into the DataSet.
dataTable: A DataTable to fill with records and, optionally, schema.
The number of rows successfully added or refreshed in the DataSet.
Even if you use the StartRecord argument to limit the number of records that are copied to the DataSet, all records in the AseDataAdapter query are fetched from the database to the client. For large result sets, this can have a significant performance impact.
An alternative is to use an AseDataReader when a read-only, forward-only result set is sufficient, perhaps with SQL statements (ExecuteNonQuery) to carry out modifications. Another alternative is to write a stored procedure that returns only the result you need.
If SelectCommand does not return any rows, no tables are added to the DataSet, and no exception is raised.
.NET Framework documentation for DdDataAdapter.fill() for the list of supported fill methods.
