DataGridView with multiple table

转载于 2008-04-11 13:16:33 发布 · 77 阅读

本文介绍了两种在DataGridView中从两个表中显示数据的方法。一种是使用SQL联接语句将两个DataTable合并为一个，另一种是利用JoinView组件来实现。虽然这两种方法都能达到目的，但各有优缺点。

Display columns from two tables in one DataGridView

There're two ways.

One way is to use SQL( join )
one DataTable, one DataAdapter.
set "DataGridView.dataSource = DataTable". It's OK
It's very easy,but disadvantage is that you can not use "dataAdapter.update"

The other way is to use JoinView
http://support.microsoft.com/Default.aspx?scid=kb;en-us;325682
two DataTables, two DataAdapters, one JoinView
The only drawback is that if you change the data of DataTable, the JoinView can't modify accordingly. You should write ReFill() method of JoinView

Public Sub ReFill(ByVal DataTable As DataTable)
Me.Clear()
Table = DataTable
Dim Row As DataRow
For Each Row In Table.Rows
List.Add(New JoinViewRow(Me, Row))
Next
End Sub
[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/55968/viewspace-1002315/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/55968/viewspace-1002315/