السلام عليكم و رحمة الله و بركاته
انا عامل فورم و ربطه بالداتا بيس و فيه DataGridView1 , DataGridView2
و الداتا بيس فيها Table1 و Table2 و ربطها ب كود ده
Public Class Form1
Dim ds As New DataSet
Dim dt As New DataTable("Table1,Table2")
Dim ConStr As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source =" & Application.StartupPath & "\Database.mdb"
Dim Conn As New OleDbConnection(ConStr)
Dim DataSet1 As New DataSet
Dim SQLstr As String = "SELECT * FROM Table1"
Dim m As String
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Static m As Integer = 0
Conn.Open()
Dim DataAdapter1 As New OleDbDataAdapter(SQLstr, Conn)
DataAdapter1.Fill(DataSet1, "Table1")
Conn.Close()
ChangePosition()
DataGridView1.DataSource = DataSet1
DataGridView1.DataMember = "Table1"
End Subده بيعرض ال Table1 فى ال DataGridView1
انا عاوز كود اخلى ال Table2 يظهر فى DataGridView2
شكرا
