Answer Posted / naresh

Data reader:
1. It is a read only and forward only data access to data.
2. You can access one table at time.
3. It can't persist the data.
4. It is comes under connected architecture.
5. One of the most advantage is it is much faster than Data
Adapter

Data set:

1. It can access multiple tables at a time.
2. It can persist the data.
3. It is a relational data cache hosted in application
domain during execution.
4. It is a disconnected architecture.
5. It can't define with out data adapter.


Yes.dataReader hold data from multiple tables. The SELECT
statement may have columns that belong to one or more
"tables in the database". By example using a JOIN
or something similar.

What is ado code?

945

---

What is data reader in ado.net?

1004

---

What is basic use of data view?

998

---

how can implement dropdownlist in particular of dataset when try to update?

2775

---

Define data adapter?

947

---

oledbdataadpter with ms access in c#.net giving exception System.Data.OleDb.OleDbException while writing adapter.update(dataset,"tabname"); how to update the database from dataset?

2375

---

What is linq and entity framework?

999

---

What is data view and variable view?

905

---

What is commandbuilder in ado.net?

1018

---

What Is Difference Between Ado And Ado.net?

1031

---

What is data control techniques?

956

---

Which database is the ado.net?

966

---

What do you know about ado.net's objects?

997

---

What are the objects of ado.net?

1063

---

What is difference between ado.net and asp net?

1034

---