ADO.NET Programming in Visual Basic™ .NET

The DataAdapter Classes

Like the Connection classes, there are separate DataAdapter classes for the OleDbClient and the SqlClient. We will be using the SqlClient versions for our demonstrations. All of what we learn applies to the OleDbClient versions as well except where noted. At the heart of the DataAdapter is the Command class. For you ADO veterans this is similar to the ADO Command object and has similar properties and methods. The big difference is that the ADO .NET Command class does not send its output to a RecordSet object. It uses another object, called a DataReader, to send a stream of data into a DataTable object, which usually resides inside a DataSet, although it does not have to. There are also separate methods for executing update ...