Answer Posted / jayeshwaree

datareader:
*connected enviornment
*reads one row at a time. By using Read() we can read the
read records of one row
*used to retrieve data as it returns a result set in a read
only and forward only mode

dataset:
*disconnected enviornment
*it is used as a container to hold one or more tables with
constraints and relations
*to update the changes made in dataset we need a data
adapter and we need to call the Update() method

How do you update a dataset in ado.net?

978

---

How can we add/remove row's in "datatable" object of "dataset"?

973

---

What is commandbuilder in ado.net?

965

---

What are the steps you will take to improve performance?

849

---

What are the namespaces used in ADO.Net to connect to a database?

1124

---

What is linq and entity framework?

947

---

What is the provider being used to access oracle database?

947

---

Define data adapter?

900

---

What is ado asp?

956

---

Is ado.net dead?

958

---

Explain the role of data provider in ado.net? What is the role of data provider in ado.net?

959

---

What is data relation in ado.net?

1002

---

What DataReader class do in ADO.NET ?

1042

---

What is the hierarchy of data in databases?

902

---

Explain the differences between oledb sql server, oledbdotnet provider?

961

---