我有两个数据表,我想从一个表中复制一行到另一个表中。我尝试过这个方法,但是我的两个表并不完全相同,它们都有共同的表头,但第二个表有更多的列,因此我需要“智能”复制,即根据列标题名称复制行。
d1:
但是这段代码:
d1:
+--------+--------+--------+
| ID | aaa | bbb |
+--------+--------+--------+
| 23 | value1 | value2 | <----copy this row
d2:
+--------+--------+--------+--------+
| ID | ccc | bbb | aaa |
+--------+--------+--------+--------+
| 23 | | value2 | value1 | <----I need this result
但是这段代码:
string rowID=23;
DataRow[] result = dt1.Select($"ID = {rowID}");
dt2.Rows.Add(result[0].ItemArray);
提供:
d2:
+--------+--------+--------+--------+
| ID | ccc | bbb | aaa |
+--------+--------+--------+--------+
| 23 | value1 | value2 | | <---- :( NOT what I need