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

If a table contains 20000 records . In a page at each time 100 records to be displayed what are the steps you will take to improve performance? Will you use dataset or datareader?

834


Explain ado.net features?

780


What two types of data providers does ADO.NET supply? What determines which one you should use?

740


How to pass multiple tables in datasets simultaneously?

809


What is commandbuilder in ado.net?

725


What is the use of sqldatareader class?

678


Give an example of a .net application which connects to microsoft access database using ado.net classes.

800


Define connection string?

791


What is data access pattern?

675


What is the advantage of ado.net?

757


Explain the two fundamental objects in ado.net?

682


What is a string variable?

660


How do you find the count of records in a dataset?

687


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

891


What are the advantages of oledb compared with other classes?

2561