Answer / amit garg

Feature of DataSet:
1.DataSet provide disconnected mode.
2.We can Use DataRelation between Table in DataSet.
3.DataSet Contain Hug of Data from database.
4.DataSet can Load a From Other Resource Like XmlFile.
DisAdvantage of DataSet
1.DataSet is slower in compare to RecordSet Because at
First Data Convert in xml before providing the user.
2.we can not use freuqent changes data in dataset because
it works as disconnected mode.

Answer / parveen atreya

DataSet is based on disconnected model. We can
Update/Delete/Edit data into dataset. As compared to
datareader data set is slow.In dataset data/information is
stored in the form of XML.dataset has many objects which
make this easy for user. read/write data operation is very
fast.

Difference between ADO and ADO.net ?

11 Answers   Accenture, BirlaSoft, College School Exams Tests, Krest, Red Apple,

---

How can you identify whether or not any changes are made to the DataSet object since it was last loaded?

0 Answers  

---

What are the different methods by which we can populate a dataset?

0 Answers  

---

What are the parameters that control most of connection pooling behaviors?

0 Answers  

---

What is the difference between Data adaptor and Data set?

0 Answers   HCL,

---

---

differences between ADO and ADO.NET

0 Answers   Microsoft,

---

What is ado.net explain with diagram?

0 Answers  

---

What is a dataset?

3 Answers  

---

How many types of data table are in SQL.NET

4 Answers   Chetu India, HCL, MAHINDRA,

---

Why do we need ado.net?

0 Answers  

---

What is aggregating data ?

0 Answers  

---

once data is fetched into dataset connection gets closed. but in datareader connection is always maintained...then why datareader is fast and mainly recommended ?

2 Answers  

---