Dataset Vs DataReader (

Submitted on: 1/4/2015 12:24:00 PM
By: (from psc cd)  
Level: Beginner
User Rating: By 3 Users
Compatibility: C#, VB.NET, ASP.NET, C++.NET
Views: 6348
     difference between dataset and 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

DotNet Guts

"Lets Make Programming Easy"

Logon to

Join us @

Report Bad Submission
Use this form to tell us if this entry should be deleted (i.e contains no code, is a virus, etc.).
This submission should be removed because:

Your Vote

What do you think of this article (in the Beginner category)?
(The article with your highest vote will win this month's coding contest!)
Excellent  Good  Average  Below Average  Poor (See voting log ...)

Other User Comments

 There are no comments on this submission.

Add Your Feedback
Your feedback will be posted below and an email sent to the author. Please remember that the author was kind enough to share this with you, so any criticisms must be stated politely, or they will be deleted. (For feedback not related to this particular article, please click here instead.)

To post feedback, first please login.