Answer Posted / guest

foreach(DataTable thisTable in myDataSet.Tables){
// For each row, print the values of each column.
foreach(DataRow myRow in thisTable.Rows)}

What is connection pooling and what is the maximum pool size in ado.net connection string?

942

---

What is the use of data grid?

955

---

What is disconnected scenario in entity framework?

1113

---

What is ole data type?

917

---

What is command class in ado.net?

1023

---

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

1336

---

What is the difference between OLEDB Provider and SqlClient?

983

---

What are the 3 major types of connection objects in ado.net?

999

---

What is executequery?

947

---

Which one of the following objects is a high-level abstraction of the connection and command objects in ado.net?

1064

---

What is execute reader in ado.net?

964

---

What is the usage of the dataset object in ado.net?

962

---

How can you add or remove rows from the datatable object of dataset?

1025

---

What is the hierarchy of data in databases?

948

---

how you will deal result set? How do you sort a dataset?If a dataset contains 100 rows, how to fetch rows between 5 and 15 only?

1008

---