Convert between SqlDataReader DataSet and DataTable

Question

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 ?

ali tuncer · 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 R · Answer

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.

Convert between SqlDataReader , DataSet and DataTable