Difference between datareader and dataset?

Answer Posted / bhupi

Data reader:it is a connection .in which we can forward the
data in only read only form,directly to the .net
application may be web or windows

Dataset: data set is the very similer to the to the Data
base ,we can say it is a duplicate copy of our original
data base ,all tha query are executed on the data set and
after that changes are made in original database

Is This Answer Correct ?    36 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between dataset and datatable?

489


What is oledb driver?

499


Does entity framework use ado.net?

507


What are the advantages of ado.net?

513


What is ambient transaction?

508






What is difference between Dataview and Datatable?

532


What is oledb connection?

511


What is the difference between sqldatareader and sqldataadapter?

498


What is concurrency? How will you avoid concurrency when dealing with dataset? (One user deleted one row after that another user through his dataset was trying to update same row. What will happen? How will you avoid the problem?)

585


What are the major challenges in accessing data from a database?

541


What is ado rdo dao in visual basic?

668


Which is faster dataset or datareader?

530


What is ado control?

526


Data reader read and forward only, how is it possible to get 2 tables of data at a time?

496


How to check if a datareader is closed or opened? IsClosed()

586