Answer Posted / rathish

go to project->add reference->adodb

DECLERATION

Dim con As ADODB.Connection
Dim cmd As ADODB.Command
Dim str, cnstr, sql As String
Dim cn As OleDb.OleDbConnection


FORM LOAD

Private Sub Form1_Load(ByVal sender As System.Object,
ByVal e As System.EventArgs) Handles MyBase.Load
con = New ADODB.Connection
con.Open("Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=c:\new folder\employee.mdb")
End Sub

in the source you have to give the path of ur file name..

What is difference between connected and disconnected architecture in ado.net?

1205

---

What is ado data control?

1040

---

Explain how to create dynamic gridview?

1019

---

Define data access layer?

1013

---

What is the use of data grid?

999

---

What are all the different methods under sqlcommand?

1031

---

How can we load multiple tables in to dataset?

1146

---

Explain ado.net features?

1105

---

What is the difference between statement and preparedstatement interface?

1053

---

What is a datareader object?

1145

---

Is entity framework better than ado.net?

1076

---

What is the role of clr?

1001

---

What is ado and rdo?

965

---

What are the key events of sqlconnection class?

1246

---

Name which operations can you not perform on an ado.net dataset?

1039

---