What are the differences between Dataset and DataReader?

Answers were Sorted based on User's Feedback



What are the differences between Dataset and DataReader?..

Answer / 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

What are the differences between Dataset and DataReader?..

Answer / saravanan

dataset is a connectionless service but data reader is a
connection oriented service..

Is This Answer Correct ?    7 Yes 0 No

What are the differences between Dataset and DataReader?..

Answer / eduardo belmonte

A ds (dataset) can be used when the connection is closed.
A dr (datareader) needs the connection open to be used.

A ds can be used to modify or delete or insert data in the
database.
A data reader can be used only to read data

A ds can let you access the info on any order at any time.
A dr lets you access the info only one time per item and
only in a sequential order.

A ds data can be loaded in longer time than a dr can be
loaded at.

A ds can contain separated and structured data from several
database tables.
A dr can contain data in one register per item, that
register can include data from serveral tables id the sql
select statement so indicates, but it has no separate
structure per table.

Is This Answer Correct ?    7 Yes 0 No

Post New Answer

More ASP.NET Interview Questions

what are the levels of securities need to be considered for the finincial web application?

1 Answers  


What is the difference between globalization and localization?

0 Answers  


How many time you can fill dataset in asp.net?

3 Answers   Syntel, Wipro,


What is .netmodule and how is different from .dll and .exe

2 Answers   NIIT,


What is application Object?

0 Answers   Infogain,






How can you apply a theme to your asp.net application?

0 Answers  


Can you edit data in the Repeater control? Which template must you provide, in order to display data in a Repeater control? How can you provide an alternating color scheme in a Repeater control? What property must you set, and what method must you call in your code, in order to bind the data from some data source to the Repeater control?

0 Answers  


How do we make a poperty read only?

1 Answers   Microsoft,


Please brief not about xsd,xslt & xml?

0 Answers  


Are there any resources for drop-in replacements for the default css that comes with the ASP.NET Website template?

0 Answers   MCN Solutions,


How is session id generated?

0 Answers  


Define page output caching?

0 Answers  


Categories