/// <summary>
/// 将两个列不同的DataTable合并成新的DataTable
/// </summary>
/// <param name="dt1">Table表括</param>
/// <param name="dt2">Table表括</param>
/// <returns></returns>
private DataTable UniteDataTable(DataTable DataTable1, DataTable DataTable2)
{
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);
//}
return newDataTable;
}