Dataset Vs DataReader (ADO.net)

<h1>DataSet Vs DataReader</h1>
Points to be consider while choosing between the DataSet and DataReader objects.<br>
<br>
1) DataSet Object has Read/Write access, While DataReader Object has Read-only
access<br>
<br>
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<br>
<br>
3) DataSet Object works under Disconnected mode, While DataReader Object has
Connected mode<br>
<br>
4) DataSet Object is Bind to multiple controls, While DataReader Object is Bind
to a single control<br>
<br>
5) DataSet Object supports Forward and backward scanning of data, While
DataReader Object supports Forward-only scanning of data<br>
<br>
6) DataSet Object has Slower access to data, While DataReader Object has Faster
access to data<br>
<br>
7) DataSet Object has Greater overhead to enable additional features, While
DataReader Object being Lightweight object with very little overhead<br>
<br>
8) DataSet Object is Supported by Visual Studio .NET tools, While DataReader
Object Must be manually coded<br>
<h1>DotNet Guts</h1>
<i>&quot;Lets Make Programming Easy&quot;</i><br>
<br>
Logon to DotNetGuts.2ya.com<br>
<br>
Join us @ DotNetGuts@YahooGroups.com<br>
<br>
<p><br>
<br>