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?

498

---

Is entity framework better than ado.net?

473

---

How do you find the count of records in a dataset?

473

---

What is difference between ado.net and asp net?

504

---

What is data adapter in ado.net with example?

509

---

---

How do you update a dataset in ado.net?

539

---

Explain why canot we use multiple inheritance and garbage collector paralelly in .net?

583

---

What is the namespaces being used to access oracle database?

508

---

How is entity framework different from ado.net?

475

---

Is it possible to load multiple tables in a Dataset?

519

---

What is full form of ado?

530

---

Which is faster ado.net or linq?

509

---

What is dbcontext and dbset in entity framework?

480

---

What is disconnected scenario in entity framework?

526

---

Explain the advantages and disadvantages of using datalist?

602

---