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 difference between Dataview and Datatable?

1067

---

What is ado or jdbc?

924

---

What are three methods for displaying data in a syncfusion datagrid

1072

---

What is ado.net and its architecture?

1176

---

What is the hierarchy of data in databases?

948

---

How can we load multiple tables in to dataset?

1090

---

What are all the different methods under sqlcommand?

985

---

Which is the feature of ado.net?

1014

---

Explain the role of data provider in ado.net? What is the role of data provider in ado.net?

1002

---

What is dataadapter in ado.net?

922

---

What is meant by executenonquery?

938

---

Define table relations?

979

---

Explain advantages of ado.net?

1050

---

What is the difference between sqldatareader and sqldataadapter?

969

---

Which name space is used to get assembly details?

992

---