C# Tutorials and offshore development in India
    Tutorials   Resources   Forum   Reviews   Communities   Interview   Jobs   Projects   Training   Your Ad Here    
Silverlight Games | Mentor | Code Converter | Articles | Code Factory | Computer Jokes | Members | Peer Appraisal | IT Companies | Bookmarks | Polls | Revenue Sharing | Lobby | Gift Shop |


Prizes & Awards
My Profile



Active Members
TodayLast 7 Days more...






Resources » Articles » ASP.NET/Web Applications »

DataReader vs. DataSet


Posted Date: 03 Sep 2008    Resource Type: Articles    Category: ASP.NET/Web Applications
Author: GeethaMember Level: Gold    
Rating: 1 out of 5Points: 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  
Sign In to add 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: ASP.NET/Web Applications


Post resources and earn money!
 
Related Resources



dotNet Slackers

About Us    Contact Us    Privacy Policy    Terms Of Use