DataReader vs. DataSet

Posted Date: 03 Sep 2008	Resource Type: Articles	Category: ASP.NET/Web Applications
Author: 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 2008

Member 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: ASP.NET/Web Applications

Post resources and earn money!

Related Resources