Answer Posted / sudha

first add the namespace

using system.Data.oledb;

OledbConnection cntn = new OledbConnection("Provider =
Microsoft.jet.oledb.12.0;datasource = (local);Integrated
security = SSPI,persistent Security = false");

provider = it depends on version of Microsoft Access like if
it is 2003 - 4.0 & if it is 2007 - 12.0

dataource - u can make it as local or provide the path to ur
database

Can you explain how to enable and disable connection pooling?

920

---

Explain the namespaces in which .net has the data functionality class.

1009

---

How to check if the Dataset has records ?

947

---

How to enable and disable connection pooling?

995

---

What is execute scalar in ado.net?

901

---

How do I delete a row from a DataTable?

1076

---

What is ole db and odbc?

859

---

What is untyped dataset?

1035

---

Which method is used to sort the data in ADO.Net?

1919

---

What is difference between entity framework and ado.net?

881

---

What are the Features of a dataset

1182

---

Compare Data Reader & Dataset in ado.net?

941

---

What is dataset and datatable in ado.net?

925

---

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

943

---

What is data relation in ado.net?

993

---