Answer Posted / sandip bhattacharya

In .net there are two provider.
1)Sql Data Provider;(for sql server)
2)Oledb Data Provider;(for other database)

and the name space are
1)System.data.sqlclient;
2)System.data.oledb;

What is openquery?

922

---

What are the main differences between classic ado and ado.net?

966

---

Which namespaces are used for data access?

1117

---

What are the advantage of ado.net?

930

---

What are the benefits of ADO.NET?

1060

---

What is the difference between Dataset. clone and Dataset.copy?

989

---

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

1171

---

What are the essential features of ado.net?

894

---

Data reader read and forward only, how is it possible to get 2 tables of data at a time?

859

---

What is the difference in record set and dataset?

974

---

What is fill method in ado.net?

920

---

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

883

---

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?

2330

---

What is the purpose of using adodb?

898

---

Why is stored procedure used in ado.net?

1028

---