如何梆定两个的字段进行分组统计?
主表A
AAA BBB CCC EEE HHH ID
011 ... ... . . 0
011 ... ... 1
011 ... ... 2
022 ... ... 3
022 . . 4
023 . . 5
子表B -----统计A表[BBB][CCC]字段数据
AAA BBB CCC ID
011 SUM SUM 0
022 1
023 2
如何梆定AAA字段进行分组统计?分别显示在DataGridView 控件上。
应如何梆定？在DataGridView 上选中即统计显示表B
dim ds AS New DataSet
Adr.Fill(ds, "表A")
Adr =New SqlDataAdapter
.
.
.
Adr.Fill(ds, "表B") '----统计正确
.
.
.
Dim PatA() As DataColumn = New DataColumn() {ds.Tables("表A").Columns("AAA"), ds.Tables("表A").Columns("ID")}
Dim chB() As DataColumn = New DataColumn() {ds.Tables("表B").Columns("BBB"), ds.Tables("表B").Columns("ID")}
ds.Relations.Add("A_B", PatA, chB)
'错误提示----创建不了关系。错在那？
[解决办法]
Dim chB() As DataColumn = New DataColumn() {ds.Tables("表B").Columns("AAA"), ds.Tables("表B").Columns("ID")}
*****************************************************************************
欢迎使用CSDN论坛专用阅读器 : CSDN Reader(附全部源代码)
http://feiyun0112.cnblogs.com/
[解决办法]
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim ds As New DataSet("NorthWind") Dim db As New LzmTW.Data.SqlDatabase(".", "NorthWind") db.Load("SELECT * FROM Orders;SELECT * FROM [Order Details]", ds, New String() {"Orders", "OrderDetails"}) ds.Relations.Add("Orders_Details", ds.Tables("Orders").Columns("OrderID"), ds.Tables("OrderDetails").Columns("OrderID")) Dim masterBindingSource As New BindingSource() Dim detailsBindingSource As New BindingSource() masterBindingSource.DataSource = ds masterBindingSource.DataMember = "Orders" detailsBindingSource.DataSource = masterBindingSource detailsBindingSource.DataMember = "Orders_Details" Me.DataGridView1.DataSource = masterBindingSource Me.DataGridView2.DataSource = detailsBindingSource End Sub