O'Reilly logo

ADO.NET Programming in Visual Basic™ .NET by Bob Howell, Steve Holzner

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required