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 dao and ado?

924

---

What is the difference between DataReader and DataSet in ADO.NET?

1154

---

Explain sqlconnection object?

994

---

Which name space is used to get assembly details?

981

---

Explain how do you connect to sql server database without using sqlclient?

1000

---

Does dapper use ado.net?

1014

---

Why do we serialize data?

939

---

Explain the difference between an ado.net dataset and an ado recordset?

1056

---

What is the meaning of executenonquery?

1050

---

What is the use of adodc?

987

---

What is the use of SqlCommand object?

1220

---

What are the steps to connect to a database?

1013

---

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

1073

---

What are the methods of XML dataset object?

1022

---

What is microsoft ole db provider for sql server?

924

---