Question: what is the difference between datareader and dataadapter?
Answer: You can use the ADO.NET DataReader to retrieve a read-only, forward-only stream of data from a database. ... A DataAdapter is used to retrieve data from a data source and populate tables within a DataSet. The DataAdapter also resolves changes made to the DataSet back to the data source.