Loading

Convert between SqlDataReader , DataSet and DataTable

Sivaiah Devara

I am using 3 layer architecture to develop project.I need too select data from database and give result to present layer in the form of present in GridView or present in labels.

and

I get data in the form of SqlDataReader ,then how to convert to DataSet or DataTable.

Which one is better to use ?

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

ali tuncer10y ago
Accepted answer
DataSet is a set of DataTables..
for example :
DataSet ds = new DataSet()
ds.Tables[0] // this is a DataTable

you can use Load method to get data from SqlDataReader

Check this link :
http://www.aspneto.com/how-to-convert-sqldatareader-to-datatable-using-load-in-asp-net-c-vb-net.html
Thiruppathi R10y ago
Dataset is best thing for you. Because we are getting more then query output from SP. Easy to bind grid or any control.but once you completed binding dispose the Dataset.