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 advantages of ado.net?

904

---

What is ado.net objects?

953

---

Which provider is used to connect ms access, oracle, etc…?

995

---

What is DataRowCollection?

1099

---

Which name space is used to get assembly details?

978

---

What are the different namespaces used in the project to connect the database? What data providers available in .net to connect to database?

1332

---

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?

2373

---

What are three methods for displaying data in a syncfusion datagrid

1063

---

What are the ado.net objects?

936

---

What are the different methods by which we can populate a dataset?

1227

---

Which is the feature of ado.net?

1006

---

What is the use of connection object in ado.net?

1047

---

What is a datagridview?

1037

---

What is the difference between executenonquery () and executescalar ()?

951

---

What are disadvantages of microsoft-provided data provider classes in ado.net?

1022

---