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 sqldatasource?

885

---

What are the 3 major types of connection objects in ado.net?

947

---

Explian About DataAdapters

977

---

What is ado.net full form?

942

---

What is data relation in ado.net?

1000

---

Which parameter of ConnectionString is used to specify the name of the database?

994

---

How to identify the controls which can be used for binding data?

960

---

What is the use of sqldatareader class?

944

---

What are all the classes that are available in System.Data Namespace?

969

---

Define Execute Reader?

1026

---

What is serialization and de-serialization in .net? How can we serialize the dataset object?

911

---

Which object holds only data and does not interact with data source?

916

---

What is an ADO.Net?

934

---

What are the different namespaces used in the project to connect the database? What data providers available in .net to connect to database?

1279

---

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

872

---