Difference between datareader and dataset?

Answer Posted / ganesh

datareader(connection oriented) is a read only and forward
only record set which will have the data retrieved based on
the select statement.we can't do DML operations through
datareader.

whereas dataset(disconnected) model which we can do all the
DML operations.

Is This Answer Correct ?    111 Yes 20 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which architecture does Datasets follow?

586


Define executenonquery?

526


What is XML serialization

589


What is defaultview in datatable?

535


What are the classes in System.Data.Common Namespace?

709






What is meant by executenonquery?

529


What are the different ado.net namespaces are available in .net?

495


What are the uses of Stored Procedure?

557


Describe datareader object of ado.net with example.

511


Which is the best method to get two values from the database?

521


What is difference between connected and disconnected architecture in ado.net?

587


What are all features of ADO.Net?

551


What is the executescalar method?

582


What is dbcontext and dbset in entity framework?

486


What are the namespaces used in ado.net for data access?

485