你在子表的afterload里写入代码,就能同步加载孙表;同理孙孙表也是这样。
If DataTables("表B").DataRows.Count = 0 Then '如果订单表没有数据
DataTables("表A").LoadFilter = "表A编号 Is Null" '不加载订单明细
Else
Dim ids As String
For Each dr As DataRow In DataTables("表B").DataRows
ids = ids & ",'" & dr("表B编号") & "'"
Next
ids= ids.Trim(",")
DataTables("表C").LoadFilter = "表B编号 In (" & ids & ")"
End If
DataTables("表C").Load()