Difference between datareader and dataset?

Answer Posted / raghavendra.v

DataReader is conncetion oriented u can find the changes in
the database reflected in data reader immediately

where as dataset is pure disconnected one you will find the
changes only when u refresh the dataset using dataadapter

Is This Answer Correct ?    50 Yes 13 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to add an aggregate column?

535


Explain sqlconnection object?

536


What is ado.net components?

507


What is difference between dataset and datatable?

511


Why ca not we use multiple inheritance and garbage collector paralelly in .net?

555






What is the difference between Data adaptor and Data set?

515


What is the full form of ado?

516


Explain how to call the sql commands asynchronously in ado.net version 2.0?

508


What is the difference between ado.net and oledb?

483


What is the difference between sqldatareader and sqldataadapter?

494


What is the role of data provider in ado.net?

552


What is serialization and de-serialization in .net?

500


How to creating a SqlCommand Object?

593


Can we load multiple tables in a dataset?

544


What are different layers of ADO.Net?

588