DataSet vs DataReader

DataSet vs DataReader

Points to be consider while choosing between the DataSet and DataReader objects.

1) DataSet Object has Read/Write access, While DataReader Object has Read-only access

2) DataSet Object Supports multiple tables from different databases, While DataReader Object Supports a single table based on a single SQL query of one database

3) DataSet Object works under Disconnected mode, While DataReader Object has Connected mode

4) DataSet Object is Bind to multiple controls, While DataReader Object is Bind to a single control

5) DataSet Object supports Forward and backward scanning of data, While DataReader Object supports Forward-only scanning of data

6) DataSet Object has Slower access to data, While DataReader Object has Faster access to data

7) DataSet Object has Greater overhead to enable additional features, While DataReader Object being Lightweight object with very little overhead

8) DataSet Object is Supported by Visual Studio .NET tools, While DataReader Object Must be manually coded

http://articles.sitepoint.com/article/dataset-datareader