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 the concept of postback in asp.net?

592


What is viewstate? In which event of the page life cycle, is the viewstate available?

605


What is a web api endpoint?

535


Explain server side state management system.

553


What is the difference between exe and dll?

556






What is a proxy in web service?

561


Can master pages be nested?

516


What is session mode in asp.net?

520


What are the different properties of server control that exists?

568


What kind of data we can store in viewstate?

578


To get the values in two different controls to match which control you use it?

532


Define satellite assemblies.

586


I have created a configuration setting in my web.config and have kept it at the root level. How do I prevent it from being overridden by another web.config that appears lower in the hierarchy?

545


How many types of sessions in asp.net?

583


What is the difference between CC and BCC?

618