What are the differences between Dataset and DataReader?

Answer Posted / kautilya

Dataset is in memory representation of the Database. where
you can create tables, relations between tables, add
primary key to tables and also manipulate the data
retrieved form the database. It allows us to work in
connection less environment.

Datareader is like forward only readonly cursor, which is
used to retrieve data. data manipulation is not possible
while using datareader. datareader continously keeps the
connection open.

Is This Answer Correct ?    13 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is redirectpermanent in asp.net?

701


Explain the function of new view engine in asp.net? : asp.net mvc

621


Can you explain architecture of your project ?

720


How do I upload a file from my ASP.NET page?

683


Explain what are delegates?

661






If I have more than one version of one assemblies, then how will I use old version (how/where to specify version number?) In my application?

620


List some of the important session state modes of asp.net.

606


Which property is used to identify the Page is Post Back in ASP.NET?

651


Can I combine classic asp and asp.net pages?

610


14. What are your Future Plans for Swatz Oils GROUP U.K?

1850


What is the use of placeholder control? Can we see it at runtime?

676


How to find out what version of asp.net I am using on my machine?

669


How many types of cache are there?

621


Using code explain Configuration Management

1499


What is the difference between page.registerclientscriptblock and page.registerstartupscript?

565