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

What is connection in ado.net?

952

---

Define atomicity?

1040

---

Explain how to copy the contents from one table to another table and how to delete the source table in ado.net?

870

---

What is sqlconnection and sqlcommand?

1128

---

What does adodb stand for?

1055

---

Is it possible to edit data in Repeater control?

966

---

What is ado control?

956

---

Explain the difference between ado and ado.net?

942

---

Can we connect two dataadapters to same data source using single connection at same time?

989

---

What is ole in excel?

942

---

Which object of ado contains datarow datacolumn collection?

966

---

What is the difference in record set and dataset?

1028

---

What is the use of Dataview?

1134

---

What are basic methods of dataadapter?

976

---

How can we load multiple tables in to dataset?

1093

---