O'Reilly logo

Programming Microsoft® ADO.NET 2.0 Core Reference, 2nd Edition by David Sceppa

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

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

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