O'Reilly logo

ASP.NET Developer's JumpStart by Ken Getz, Paul D. Sheriff

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

Using the DataReader Object

ADO provided a Recordset object, and this object allowed for both connected and disconnected as well as cursored and cursorless data access. There were so many options that many developers never really figured out all that an ADO recordset could do. To avoid this overloading nightmare, ADO.NET provides separate objects, based on functionality. The DataAdapter object (SqlDataAdapter or OleDbDataAdapter) contains SQL command information and connection information, and it can go out and retrieve or manipulate data for you. The DataSet object provides a client-side cache for working with data.

Under the covers, there must be some read-only, forward-only, highly optimized means of retrieving data as quickly as possible ...

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