Difference between Dataset and Datareader?

Data Set is a connection-less service and Data reader is a connection oriented service. Dataset is used to store the data, it contains collections of Datatable. Datareader is used to connect to the database for retrieving data. Data Reader – Forward only where as Dataset – Can loop through dataset. Data Reader – Connected Recordset where as DataSet – Disconnected Recordset Data Reader – Less Memory Occupying where as DataSet – It occupies more memory Data Reader – Only Single Table can be used where as Dataset – Datatable Concept allows data to be stored in multiple tables. Data Reader … Click here to continue…..