窗体如下图:
上面DataGridView1数据为Northwind中的Orders表
下面DataGridView2数据为Northwind中的Order Details表
两表的外键为:Orders.OrdersID和Order Details.OrderID
目标:实现点击Button1按钮,关联更新两个表。
窗体代码:
Public Class Form1
Dim bs_orders As New BindingSource
Dim da_orders As New SqlClient.SqlDataAdapter
Dim bs_ordersdetails As New BindingSource
Dim da_ordersdetails As New SqlClient.SqlDataAdapter
Dim ds As New DataSet
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
da_orders = New SqlClient.SqlDataAdapter("Select * from Orders", cn)
da_orders.Fill(ds, "[orders]")
bs_order