多个DataTable合并成一个DataTable
List<DataTable> TableList = new List<DataTable>();
DataTable dt1 = new DataTable();
DataTable dt2 = new DataTable();
TableList.Add(dt1);
TableList.Add(dt2);
DataTable tempDataTable = TableList[0].Clone();
object[] obj = new object[tempDataTable.Columns.Count];
foreach (DataTable item in TableList)
{
for (int i = 0; i < item.Rows.Count; i++)
{
item.Rows[i].ItemArray.CopyTo(obj, 0);
tempDataTable.Rows.Add(obj);
}
}
return tempDataTable;
DataTable dt1 = new DataTable();
DataTable dt2 = new DataTable();
TableList.Add(dt1);
TableList.Add(dt2);
DataTable tempDataTable = TableList[0].Clone();
object[] obj = new object[tempDataTable.Columns.Count];
foreach (DataTable item in TableList)
{
for (int i = 0; i < item.Rows.Count; i++)
{
item.Rows[i].ItemArray.CopyTo(obj, 0);
tempDataTable.Rows.Add(obj);
}
}
return tempDataTable;