Distinguish b/w DataSet and DataReader Objects:-

DataSet vs DataReader:-

Dataset
Read/write access to date
Includes multiple tables from different databases
Disconnected
Bind to multiple controls
Forward and Backward scanning of data
Slower access
Supported by Visual Studio 2008 Designer

DataReader
Read - only
Based ob one SQL statement from one database
Connected
Bind to one control only
Forward - only
Faster access
Manually coded

Key Points
DataSet objects are complex objects that enable you to store multiple DataTables
of data from a data source. DataSet objects consume a lot of resources.
DataReader objects are lightweight objects that you can use for read-only access to
the data in a database. Because most of the data on a Web page must only be read,
you typically use more DataReader objects than DataSet objects if you require
higher performance.

Lesson Review:-
* What is the DataSet?
*What is the DataReader ?