.net中实现datagridview级联

在winform的开发中,有时候会遇到这样的需求。

在一个表单上放两个DataGridView分别显示主从表的信息。如GridA放主表信息和GridB放从表信息

当点击GridA选中一行数据时,在GridB中显示对应的从表记录:

实现步骤：

1。新建Winform工程

2。在表单上创建两个Datagridview,分别命名为GridA和GridB

3。实现Load事件.

Imports System.Data.SqlClient Public Class Form1 Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Try Dim con As New SqlConnection("server=.;user=sa;database=Northwind") Dim adp As New SqlDataAdapter("select * from Customers;select * from Orders", con) Dim ds As DataSet = New DataSet("Northwind") adp.Fill(ds) ds.Relations.Add(New System.Data.DataRelation("CustOrders", ds.Tables(0).Columns("CustomerID"), ds.Tables(1).Columns("CustomerID"))) GridA.DataSource = ds GridA.DataMember = ds.Tables(0).ToString() GridB.DataSource = ds GridB.DataMember = ds.Tables(0).ToString & ".CustOrders" Catch ex As Exception MsgBox(ex.Message) End Try End Sub End Class