The Fill method retrieves rows from the data source using the SELECT statement specified by an associated Select Command property.The connection object associated with the SELECT statement must be valid, but it does not need to be open.If the incoming data contains unnamed columns, they are placed in the Data Set according to the pattern "Column1", "Column2", and so on.

When the SELECT statement used to populate the Data Set returns multiple results, such as a batch SQL statements, if one of the results contains an error, all subsequent results are skipped and not added to the Data Set.

We can use the Fill method multiple times on the same Data Table.

Note When handling batch SQL statements that return multiple results, the implementation of Fill Schema for the OLE DB .

NET Data Provider retrieves schema information for only the first result.

This would free up the connection so that it could be used by other applications, improving our application's scalability.

Disconnected Recordsets also made applications more scalable in other ways.

The four properties are set to Command objects that are used when data is manipulated.

For instance, when we call the Data Adapter's Fill method to retrieve data from a data source and pour it into a Data Set, the Command object in the Select Command property is used.

Because the Data Set is independent of the data source, a Data Set can include data local to the application, as well as data from multiple data sources. NET Framework has a Data Adapter object: the OLE DB .