What is difference between data set and data reader?
Some major differences between dataset and datareader are as folows :-
1) The DataReader gives forward-only and read-only access to the data, while the DataSet object can hold more than one table (in other words rowset) from the similar data source as well as the relationships between them.
2)The Dataset is a disconnected architecture but datareader is a connected architecture.
3)The Dataset can persist contents while the datareader can not persist contents, they are only forward .