Answer Posted / yasir a. mughal

 DataReader (Connection Oriented) is a forward only and
read only data while DataSet (Disconnected) is used to
maintain relationships between multiple tables.
 You can access one table at a time while it is define with
multiple tables.
 DataReader can't persists the data while DataSet can
persist the data
 DataReader operation is faster than DataSet operation.
 DataReader is connection oriented you can find the changes
in the database reflected in data reader immediately, where
as DataSet is pure disconnected one you will find the
changes only when you refresh the dataset using DataAdapter.

but conclusion....

Another often cited issue knows when to use DataReader as
opposed to DataSet objects. As a rule, if you don't need the
data once it has been read then uses a DataReader. The
DataReader offers a forward-only trip through data, whereas
DataSet allows you access to a group of data that may be
necessary to populate an ASP.NET Repeater or similar control.

What is aggregating data ?

909

---

Can we connect two dataadapters to same data source using single connection at same time?

932

---

What are dcl commands?

955

---

What is dataadapter in ado.net?

873

---

how you will deal result set? How do you sort a dataset?If a dataset contains 100 rows, how to fetch rows between 5 and 15 only?

944

---

What is a dataview?

921

---

What is an ado?

935

---

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

1173

---

If a table contains 20000 records. In a page at each time 100 records to be displayed.

839

---

How can we save all data from dataset?

939

---

Is entity framework better than ado.net?

928

---

What is aggregate root?

998

---

how Sequence to connect and retrieve data from database using dataset?

1213

---

Define Execute Reader?

1016

---

If we are not returning any records from the database, which method is to be used?

1273

---