合并DataTable

DataTable dt3 = dt1.Clone();

for(inti = 0;i < dt2.Columns.Count;i++)

{

dt3.Columns.Add(dt2.Columns[i].ColumnName);

}

object[] obj = new object[dt2.Columns.Count];

for(inti = 0;i< dt1.Rows.Count;i++)

{

dt1.Rows[i].ItemArray.CopyTo(obj,0);

dt3.Rows.Add(obj);

}

 

if (dt1.Rows.Count>= dt2.Rows.Count)

{

for (inti = 0; i < dt2.Rows.Count;i++)

{

for (intj = 0; j < dt2.Columns.Count;j++)

{

dt3.Rows[i][j+ dt1.Columns.Count]= dt2.Rows[i][j].ToString();

}

}

}

else

{

DataRow dr3;

for (inti = 0; i < dt2.Rows.Count- dt1.Rows.Count; i++)

{

dr3 = dt3.NewRow();

dt3.Rows.Add(dr3);

}

for (inti = 0; i < dt2.Rows.Count;i++)

{

for (intj = 0; j < dt2.Columns.Count;j++)

{

dt3.Rows[i][j+ dt1.Columns.Count]= dt2.Rows[i][j].ToString();

}

}

}