Answer / umamahadevan

DataSet

Data set can be said as a temporary data base which works
on disconnected architecture which stores schema and data
in application memory area..It fetches all data at a time..
DML is entertained here

DataReader

Datareader is like a forward only recordset. It fetches one
row at a time.DataReader is readonly so we cannot do any
transaction on them. DataReader will be the best choice
where we need to show the data to the user which requires
no transaction ie reports. Due to DataReader is forward
only we cannot fetch the data randomly. .NET Dataproviders
optimizes the datareaders to handle the huge amount of data.

Answer / satish

The DataSet consists of a collection of DataTable objects
that you can relate to each other with DataRelation
objects. A DataSet can read and write data and schema as
XML documents..The DataReader object is the ADO.NET
counterpart of the read-only, forward-only default ADO
cursor

Answer / payal

1)Data set is work in diconnected architure.
Datareader is work in connected architure.

2)according to speed datareader is faster than dataset.

3)In case of dataset it contain all
tables,relations,constriants which is not in datareader so
that speed of datareader is fast.

4)Data set can persist records where datareader is not.

5)we can save ,update data in dataset and save using
acceptchanges method where datareader cannot.

6)datareader is forward only.where dataset is not.

Answer / kamlesh sharma

The DataSet consists of DataTable objects
that you can relate to each other with DataRelation
objects (and dataset is disconnected data model)

The datareader is connected model(connection must be open
while operation performs)
and it is state forward read only counter part of ADO.net

What is asp net_sessionid?

0 Answers  

---

Is asp.net mvc front end or backend? : Asp.Net MVC

0 Answers  

---

When a dropdownlist has been added by some records and it has been binded why it is not executing i'm facing this error pls help me ? if (is!pageposback) { arraylist books = new arraylist; books.add ("gone with the wind"); books.add ("rahulsriramprakash"); books.add ("vishal"); dropdowndisplay.datasource=books; dropdowndisplay.databind(); } The error is : 1) The dropdowndisplay does not exist.

5 Answers   Netsweeper,

---

How do you insert multiple rows from a grid view to database table under a single transaction?

1 Answers  

---

Explain about Application and Session Events ?

0 Answers  

---

How do I send e-mail from an ASP.NET application ?

1 Answers  

---

What are different types of authentication techniques that are used in connection strings to connect .net applications with microsoft sql server?

0 Answers  

---

explain code with datachaching with example

0 Answers  

---

If Instancing = Single use for ActiveX Exe, how will this be executed if there are 2 consecutive client requests ?

0 Answers   DELL,

---

How information about the user's locale can be accessed?

0 Answers   MindCracker,

---

What is voluum?

0 Answers  

---

Any one can tell how we store tiff format images in database and retrive from the database(need for tiff format only)

0 Answers   Tricom,

---