ADO.NET Programming in Visual Basic™ .NET

The DataAdapter Class

The DataAdapter class contains four Command objects and some methods for populating and updating DataSets from the commands. Essentially, the DataAdapter is a worker class that holds the four Command objects and has the ability to execute the commands and send the results to a DataSet. The DataAdapter knows how to build update, insert, and delete statements from the context of the Select statement provided by the programmer. It also knows how to generate parameter lists. To do this it uses a helper class called the SQLCommandBuilder.

The Fill Method

The Fill method causes the DataAdapter to execute the Command object in the SelectCommand property, generate a DataReader object to obtain the results, then pump the results ...