vb.net 把datatable的值添加到另一个datatable

Question

比如
datatable1 datatable2
id name id name
1 aa 2 bb
把datatable2的值添加到datatable1中
datatable1变成
id name
1 aa
2 bb
有没这样的语句?

Answer 1

首先按照你的例子定义2个DataTable:

dim csDataTable1 as new DataTable
csDataTable1.columns.add("id")
csDataTable1.columns.add("name")
dim csDataRow1 as DataRow = csDataTable1.NewRow()
csDataRow1.item("id") = 1
csDataRow1.item("name") = "aa"

dim csDataTable2 as DataTable = csDataTable1.clone
dim csDataRow2 as DataRow = csDataTable1.NewRow()
csDataRow2.item("id") = 2
csDataRow2.item("name") = "bb"

接下来把Table2里的数据加到Table1里去:

For each csDr as DataRow in csDataTable2.rows

csDataTable1.import(csDr )

next

如果2个表种可能有主键一样的数据，那么还需要在循环中判断一下，相同主键存在的数据不添加。本回答被提问者和网友采纳