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 are the ado.net objects?

944

---

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

1012

---

What are the key events of sqlconnection class?

1196

---

What is Dataset Object?

1010

---

can we create synonymn in ms access,sql server,my sql if so explain me with example

2089

---

Why do we use sqldataadapter?

951

---

What are the data access namespaces in .NET?

1212

---

What is the default timeout specified for "sqlcommand.commandtimeout" property?

1054

---

Define isolation?

972

---

How do we use stored procedure in ADO.NET and how do we provide parameters to the stored procedures?

971

---

Which object of ado contains datarow datacolumn collection?

966

---

What is ado.net full form?

993

---

What are the major difference between classic ADO and ADO.NET?

1013

---

What are the advantages of oledb compared with other classes?

2797

---

What are two important objects of ADO.Net?

1029

---