C# Tutorials and offshore development in India
    Tutorials   Resources   Forum   Communities   Interview   Jobs   Projects   Offshore Development    
Silverlight Tutorials | Mentor | Code Converter | Articles | Code Factory | Computer Jokes | Members | Peer Appraisal | IT Companies | Bookmarks | Revenue Sharing |


Prizes & Awards
My Profile



Active Members
TodayLast 7 Days more...

New Feature: Community Sites: Create your own .NET community website and start earning from Google AdSense ! It's Free !




Difference between dataset and Datareader:


Posted Date: 01 May 2008    Resource Type: Articles    Category: General

Posted By: Asha Mathews       Member Level: Gold
Rating:     Points: 10



Dataset

1. Data access using dataset is known as dis-connected architecture.

2. Dataset will be connected to the dataset for a short period of time as the data is read at one shot.

3. Dataset is a heavy weight object as a set of data is read at once.

4. Accessing data using dataset is faster.

5. If any modifications are done in the dataset then there is a method to push the updated values from the dataset to the database.

Datareader

1. Data access using datareader is known as connected architecture.

2. Datareader will remain connected to the dataset till all the values from the dataset are read as the values are read one at a time.

3. It is a light weight object since the values are read one at a time.

4. Accessing data using datareader is slow.

5. If any modifications are done in dataset then
there is no way to push the updated value from the dataset to the database. It is read-only and forward-only.




Responses

Author: venkat kamal    04 May 2008Member Level: Gold   Points : 2
Data set

1.Data set is a disconnected architecture
2.Data set can persist contents.
3.Data set can hold more than one table of the same data source or of different data sources as well as the relation between them.
4.Data set speed is slow.

Data Reader

1.Data Reader is a connected architecture.
2.Data Reader cannot persist contents as it is forward and read only.
3.Data Reader cannot hold tables as well as the relation as it is forward and read only access to the data.
4.Data Reader is very fast.




Author: @@@ Hyderabadi Biryani @@@    05 May 2008Member Level: Diamond   Points : 2
Hi Venkat,
This is not a forum to post the answers. This is article and you need to comment on the "how good the article is"
Hi Asha,
Its good information, but you need to put more information around this to call as an article.
keep it up..
Thanks -- Vj


Author: Gaurav Agrawal    20 Jun 2008Member Level: Silver   Points : 1
Hi
It is good article.
Keep Posting and share your knowledge with your fellow developers.
Happy Programming.

Regards
Gaurav


Author: krishna mohan    20 Jun 2008Member Level: Bronze   Points : 1
In Dataset we can have data from 2 or more tables. where as datareader can't do that.


Author: Satyanarayan SushilKumar Bajoria    20 Jun 2008Member Level: Diamond   Points : 2
Hi,
Nice article.
Keep posting such article.
You can elaborate more in this.
By the way nice attempt to clarify difference betwwen datareader and dataset.



Author: Bindu Bujji    08 Jul 2008Member Level: Gold   Points : 2
Hi,
Nice article. Thanks for sharing. I found the below differences as well.

Dataset:
Multiple table can be stored in Dataset with Relationship

DataReader:

In DataReaderit will retrieve only 1 record at a time
when second record it retrieve then first record will be detroyed from memory. DataReader reads the data in sequential mode.

Bindu


Author: UltimateRengan    09 Jul 2008Member Level: Diamond   Points : 0
hi ,
nice article continue for sharing ur knowledge


Author: mahalakshmi    10 Jul 2008Member Level: Gold   Points : 2
Hi Asha,

Nice article u have sent.
thanks.
keep posting.share ur knowledge with us.

I think u can add the following points also,

Dataset

->v can modify data.
->It supports paging
->support XML

Datareader :

->doesn't support paging
->used for reading purpose



Author: Roopesh Babu Valluru    15 Jul 2008Member Level: Gold   Points : 0
thx for ur article...


Feedbacks      
Popular Tags   What are tags ?   Search Tags  
(No tags found.)

Post Feedback


This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.
Next Resource: Client Side Script to Export to Excel 2007
Previous Resource: Common Dialogs
Return to Discussion Resource Index
Post New Resource
Category: General


Post resources and earn money!
 
Related Resources



dotNet Slackers   BizTalk Adaptors    Web Design

silicone halloween masks

Contact Us    Privacy Policy    Terms Of Use