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 !




DataReader vs. DataSet


Posted Date: 03 Sep 2008    Resource Type: Articles    Category: Web Applications

Posted By: Geetha       Member Level: Gold
Rating:     Points: 5



DataReader
1) The data retrieved through a DataReader is read-only.
2) A DataReader lasts as long as the connection to the database is open. It can’t be persisted in a cookie or a session variable. Data Reader is connection oriented.
3) A DataReader is faster than a Dataset.
4) Data in a DataReader can be read forward only.
5) Can’t update a data source through a DataReader.

DataSet
1) The data retrieved through a DataSet is read and write.
2) A DataSet lasts only until the page is reloaded unless it’s somehow persisted (ex:in a session variable). Dataset is not connection oriented.
3) A DataSet is slower than a DataReader.
4) Data in a Dataset can be read in both forward and backward direction.
5) Can make changes to data in a DataSet and then upload those changes back to the data source.




Responses

Author: Venkat    17 Sep 2008Member Level: Silver   Points : 1
nice one.
But if you give some example with this means which should be very easy to understand


Feedbacks      
Popular Tags   What are tags ?   Search Tags  
DataSet  .  DataReader  .  

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: Printing contents of controls in .Net
Previous Resource: Themes and Skins
Return to Discussion Resource Index
Post New Resource
Category: Web Applications


Post resources and earn money!
 
Related Resources



dotNet Slackers   BizTalk Adaptors    Web Design

web conferencing

Contact Us    Privacy Policy    Terms Of Use