Loading
What is the difference between datareader and dataadapter
3 Answers
Please refer to the following URLs to know the differences between DataReader and DataAdapter,
http://onlydifferencefaqs.blogspot.in/2012/07/adonet-difference-faqs-1.html
http://onlydifferencefaqs.blogspot.in/2012/08/difference-between-datareaderdataset.html
Umar AliPosted Sep 1, 2012, 1:34 PM
Data Reader:Data Reader is Nothing but It can be Read only Forword only Access data from Database ,It is faster,It can returns Onyl One record from Database.
Data Adapter:Data Adapter is Bridge Btween the Dataset and Database,it can be used Fill() method like,
dataset ds=new Dataset();
Sqldataadapter da=new SqldataAdapter("select Query",Con);
ds.Fill("Tablename",ds);
Data Adapter:Data Adapter is Bridge Btween the Dataset and Database,it can be used Fill() method like,
dataset ds=new Dataset();
Sqldataadapter da=new SqldataAdapter("select Query",Con);
ds.Fill("Tablename",ds);
P NarasimhaPosted Jan 22, 2009, 3:56 AM
Datareader reads the record from the database one by one and forward only.
DataAdapter is a bridge which is Intract between datasource and datatable.
Sanjeev SinghPosted Jan 21, 2009, 4:26 AM