Sams Teach Yourself ADO.NET in 21 Days

Retrieving Data

The first method that most developers will invoke when using a data adapter is the Fill method. The Fill method is typically overloaded to support a variety of arguments that are used to populate data either in a DataTable or in one or more DataTable objects contained in a DataSet. For example, the Fill method of OleDbDataAdapter contains six public signatures that enable you to populate a DataTable, a DataSet, a DataTable with a specific mapping name, a specific range of rows in table in a DataSet, and even a DataTable or DataSet with data from an ADO Recordset object.

Note

In addition, OleDbDataAdapter supports four protected signatures for the Fill method that are inherited from DbDataAdapter but can't be accessed because ...