Last post Mar 20, 2015 11:04 AM by Mikesdotnetting
Mar 20, 2015 09:44 AM|sudip_inn|LINK
when know that dataset is disconnected and data reader is connected. when we just fetch data the people use data reader for its performance but i like to know couple of situation where people would prefer to use dataset instead of data reader. just tell
me those scenarion where dataset would be right choice. thanks
Mar 20, 2015 11:04 AM|Mikesdotnetting|LINK
You would use a DataSet if you wanted to get two separates sets of data and create a relationship between them. You would use a DataSet (DataTable, preferably) if you wanted to filter or sort the data in the client application. You could use a DataTable
if you want to bind the same data to multiple controls - e.g. you have a list of countries that you want to bind to multiple dropdowns on the same page.
However, in pretty much every case, there are better solutions that use a DataReader.