合并两个数据表作为单个数据表 [英] Merge two datatable as a single one
问题描述
将具有相同行的两个数据表合并为一个,但表的条件不同。
我已将该数据表设置为数据集,因为即时通讯使用两个选择查询
例如,
tbl 1
S.no,MeetingName,由
分配
1 abc A
2 wer A
tbl 2
S .no,MeetingName,指定
1 abc B
2 wer B
我想要它
S.no,MeetingName,由
分配
1 abc A
2 wer A
3 abc B
4 wer B
firstDataTable.Merge(secondDataTable);
merge two data table with same row into single one,but the condition for the table differs.
"i have set that data table as a data set because i m using two select query"
For instance,
tbl 1
S.no, MeetingName,Assigned by
1 abc A
2 wer A
tbl 2
S.no, MeetingName,Assigned by
1 abc B
2 wer B
I want it as
S.no, MeetingName,Assigned by
1 abc A
2 wer A
3 abc B
4 wer B
firstDataTable.Merge(secondDataTable);
这篇关于合并两个数据表作为单个数据表的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!