* The DataAdapter is used as a bridge between DataSet and a Data Source for retrieving and saving data. It uses the Fill( ) method to change the data in DataSet and Update( ) method to change the data in Data Source. The Namespace used in System.Data.Common and Assembly is System.Data.dll. DataReader provides a means of reading a forward only stream of data from database.This Class cannot be inherited. To read the values ,you must call the ExecuteReader( ) method of command object. While the DataReader is in use, the associated SqlConnection is busy serving the DataReader and at that time no other operation can be performed on Connection excepting closing it. So Close( ) method is called
* In DataAdapter there is no need to open a connection explicitely while in execution of DataReader we have to call the Open( ) method of connection.DataReader reads the Data only in read-only, forward-only mode.Results are returned as the query executes and are stored in the network bufferon the client until you request then using the Read( ) method. DataReader increases the performance by retrieving data as soon as it is available rather then waiting for the entire result of the query to be returned(DataAdapter case).
If you have the better answer, then send it to us. We will display your answer after the approval.
Rules to Post Answers in OneStopFAQs.com:-
There should not be any Spelling Mistakes.
There should not be any Gramatical Errors.
Answers must not contain any bad words.
Answers should not be the repeat of same answer, already approved.