Difference between datareader and dataset?

Answer Posted / abhijeet kumar sharma

DataReader is faster for read data.DateReader is readonly
propurse,DataReader read data between reader Read() and
close() methods.When we read data from database help of
DataReader then database connection is must open.

DataSet is disconnected architecture. We store multiple
data at a time in dataset.

Is This Answer Correct ?    6 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Describe connection object in ado.net

784


What is a serialized object?

743


What is dataset object? Explain the various objects in dataset.

847


Do you use stored procedure in ado.net?

798


Does entity framework use ado.net?

748


What does sqldatareader return?

735


What is a dynaset in access?

829


Is ado.net an orm?

749


What is typed dataset ?

910


What is a sqldataadapter?

776


What is the advantage of ado.net?

778


Define atomicity?

812


What is dao and ado?

728


Explain how to pass multiple tables in datasets simultaneously?

806


What are the parameters that control most of connection pooling behaviours?

844