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 we connect two dataadapters to same data source using single connection at same time?

1036

---

What is data access pattern?

1003

---

Explain how to pass multiple tables in datasets simultaneously?

1084

---

How do you merge 2 datasets into the third dataset in a simple manner?

1059

---

How to check if the Dataset has records ?

1056

---

What is difference between datatable and dataset?

1131

---

How do you implement locking concept for dataset?

1048

---

What are the ado.net objects?

981

---

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

966

---

How can we load multiple tables in to dataset?

1146

---

What are dcl commands?

1051

---

What are the pre-requisites for connection pooling?

1060

---

What are the benefits of ADO.NET?

1173

---

What does executenonquery () method return?

988

---

What are all the commands used with Data Adapter?

1094

---