Answer Posted / prakash tiwari

Data Reader will read only one record at a time.So memory
consumption will be less,it is purely connection oriented
it will use connection exclusively when datareader is
closed.the memory will be released on the server machine
and connection will be used for any other purpose.

Data Adapter acts as a mediator between dataset and
database server.
it will read data from the database server and places with
in dataset
the manipulations on the dataset will be updated with the
database server

Which parameter of ConnectionString is used to specify the name of the database?

983

---

Explian About DataAdapters

966

---

What is the difference between Dataset. clone and Dataset.copy?

988

---

Explain About ado.net components/objects. Usage of data adapters and tell the steps to retrieve data.

1023

---

What is data adapter in ado.net with example?

940

---

What is ado.net connection?

903

---

What is a sqldataadapter?

944

---

What are the essential features of ado.net?

894

---

What is bubbled event can you please explain?

962

---

What are the steps you will take to improve performance?

837

---

Describe ado.net object model in detail.

943

---

What is difference between dataset and datatable?

1081

---

Does executenonquery return a value?

881

---

What is connected architecture in ado.net?

969

---

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

935

---