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 do you know about ado.net's objects?

992

---

What is ado.net code?

920

---

How to create data relations?

986

---

What is the difference between DataReader and DataSet in ADO.NET?

1153

---

What is ado net stands for?

962

---

Which method is used by command class to execute SQL statements that return single value?

1038

---

What are three methods for displaying data in a syncfusion datagrid

1063

---

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

1323

---

What are the 3 major types of connection objects in ado.net?

993

---

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

974

---

Explain the basic use of "dataview" and explain its methods.

992

---

How do you update a dataset in ado.net?

1016

---

What is microsoft ole db provider for sql server?

921

---

Explain the difference between data reader and data set?

914

---

What is the namespaces being used to access oracle database?

1074

---