What Is a SqlDataAdapter Object?
The SqlDataAdapter class acts as a bridge between the connected and disconnected halves of the ADO.NET object model. You can use a SqlDataAdapter to pull data from your database and store it in your DataSet. The SqlDataAdapter can also take the cached updates stored in your DataSet and submit them to your database. Chapter 10 will cover updating your database with SqlDataAdapter objects. In this chapter, we will focus on using SqlDataAdapter objects to fetch data from your database.
How the SqlDataAdapter Differs from Other Query Objects
When I describe the SqlDataAdapter class to database programmers, most nod their heads and say that it sounds similar to the ADO Command object, the RDO rdoQuery object, and the ...
Get Programming Microsoft® ADO.NET 2.0 Core Reference, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
