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.

Answer / saravanan

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

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.

What is the difference between mvc and asp.net? : Asp.Net MVC

0 Answers  

---

Explain Authentication mechanism in dotnet

0 Answers   BirlaSoft,

---

Hi, We have a user control that have button Now we use this user control on different aspx pages. We want when we click on the user control button then button behave differently on different page (Dynamacilly).

2 Answers   HCL,

---

What Are Different Types of Debbugers

2 Answers   Accenture, TCS, Wipro,

---

What is request and response in asp.net?

0 Answers  

---

How do you change the session time-out value?

0 Answers   TryTechnicals Pvt Ltd,

---

What is _viewstart?

0 Answers  

---

What method do you use to explicitly kill a users session?

2 Answers   Siebel Systems,

---

Guys can anobody tell what is Conditional Bloating in asp.net ??

1 Answers  

---

Explain ViewState?

0 Answers   QuestPond,

---

Difference between ASP & ASP.NET Session State

1 Answers   Cognizant, Wipro,

---

What is the difference between session state and session variables ?

6 Answers   Digital GlobalSoft,

---