Imports System.Data
Imports System.Data.OleDb
Public Class Form1
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim con As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\poonam\eg.mdb"
Dim mycon As New OleDbConnection(con)
Dim con1 As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\db1.mdb"
Dim mycon1 As New OleDbConnection(con1)
Dim q1 As String = "select * from t1"
Dim da As New OleDbDataAdapter(q1, mycon)
Dim q2 As String = " select * from t1"
Dim da1 As New OleDbDataAdapter(q2, mycon1)
Dim ds As New DataSet
Dim ds1 As New DataSet
da.Fill(ds, "t1")
da1.Fill(ds1, "t1")
DataGrid1.DataSource = ds.Tables(0).DefaultView
DataGrid2.DataSource = ds1.Tables(0).DefaultView
End Sub
End Class
No comments:
Post a Comment