/// <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; |
} |
by: 发表于:2018-01-03 10:44:28 顶(0) | 踩(0) 回复
??
回复评论