O'Reilly logo

Sams Teach Yourself ADO.NET in 24 Hours by Paul Bertucci, Jason Lefebvre

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

Limitations of the DataReader

Though the DataReader is faster and carries less overhead than binding to a DataSet, there are some limitations associated with using it. For instance, if you plan to use the paging features of Web controls, such as the DataGrid, you'll need to handle the data paging yourself. For more information, please see Hour 12, “Formatting ASP.NET List Controls.” Additionally, it's not possible to sort, filter, or manipulate the data while using a DataReader, since it is read-only and forward-only.

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