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 are the various methods provided by the DataSet object to generate XML?

1004

---

What is concurrency? How will you avoid concurrency when dealing with dataset? (One user deleted one row after that another user through his dataset was trying to update same row. What will happen? How will you avoid the problem?)

1000

---

What are all the commands used with Data Adapter?

1043

---

What is ado net stands for?

970

---

What is ole in excel?

942

---

Describe ado.net object model in detail.

997

---

Explain the difference between data reader and data adapter?

973

---

What is ado and dao?

960

---

Explain the architecture of ado.net?

1068

---

Is entity framework better than ado.net?

1017

---

What we do with the object of ado.net dataset after using it?

1041

---

What is ado oledb and odbc?

945

---

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

1024

---

What is ado.net objects?

965

---

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

1077

---