相同的表结构使用DataTable是如何合并的？

最新推荐文章于 2020-07-27 09:22:03 发布

wangjrong

最新推荐文章于 2020-07-27 09:22:03 发布

阅读量457

点赞数

文章标签： object

本文链接：https://blog.csdn.net/wangjrong/article/details/4553762

版权

DataTable DataTable1 = new DataTable();
DataTable DataTable2 = new DataTable();
DataTable newDataTable = DataTable1.Clone();

object[] obj = new object[newDataTable.Columns.Count];
for (int i = 0; i < DataTable1.Rows.Count; i++)
{
    DataTable1.Rows[i].ItemArray.CopyTo(obj,0);
    newDataTable.Rows.Add(obj);
}
for (int i = 0; i < DataTable2.Rows.Count; i++)
{
    DataTable2.Rows[i].ItemArray.CopyTo(obj,0);
    newDataTable.Rows.Add(obj);
}
//或者
DataTable DataTable1 = new DataTable();
DataTable DataTable2 = new DataTable();

object[] obj = new object[DataTable1 .Columns.Count];
for (int i = 0; i < DataTable2.Rows.Count; i++)
{
    DataTable2.Rows[i].ItemArray.CopyTo(obj,0);
    DataTable1.Rows.Add(obj);
}