Answer Posted / chitaranjan mallick

- Data Reader apply only Select Statement, It can featch data from multiple Table Through Multiple Select Statement separated by Semicolon(;) Likes For Ex:
SqlCommand cmd=new SqlCommand("Select * from Emp";" Select * From Dept",Con);
DataReader dr=cmd.ExecuteReader();
dr.NextResults();
Here NextResults() Navigate from One Tables to Anather Tables
- It is Readonly, It can featch single Record At a Time..

What does executereader return?

897

---

How to read data with the sqldatareader ?

921

---

What is the difference between ado.net and oledb?

906

---

What is Data view?

1006

---

What are the advantages and drawbacks of using ado.net?

1042

---

What is the difference between ADO and ADO.Net?

1021

---

Define Execute Reader?

1016

---

What two types of data providers does ADO.NET supply? What determines which one you should use?

940

---

What are ado.net objects?

1009

---

What are the advantages and disadvantages of using datalist?

984

---

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

938

---

How can we add relation between tables in a dataset?

937

---

What is the difference between SqlCommand and SqlCommandBuilder?

998

---

What are the different methods available under the sqlcommand class to access the data?

999

---

What is ado rdo dao in visual basic?

1100

---