Retrieve data using datareader/dataset..another way...???

jakeriggs's Avatar
Go4Expert Member
Hi.....

I am using MsSQL server as my back end database and I want to retrieve data and place it to listview....
my question is, should users use DataReader or DataSet to retrieve data??? or there is another way...???

thanks for reply....
0
jwshepherd's Avatar, Join Date: Aug 2007
Team Leader
This article should help a bit. http://aspnet.4guysfromrolla.com/articles/010208-1.aspx
0
dotnetexpert's Avatar
Light Poster
using the datareader is much more efficient than dataset.

but you can use datareader only when you don't need any updation in the data after retiving the data from Db.

using the dataset would be preferable when you need to perform add,edit operations on data.