Define DataReader and DataAdapter in ADO.NET.1. DataReader : It is lightweight class that provides connected and forward-only data access. It uses connection object exclusively. You can read data; you can’t modify data using DataReader.
2. DataAdapter : This class provides disconnected data access. It opens a data connection just long enough to retrieve the data, and loads the data into a DataSet, thus provides in-memory copy of the data.
|