c#将两个datatable合并到一起的方法

两个相同结构的datatable,现在要把它们的数据合并起来,下面是一个解决这个问题的函数

using System.Linq;

/// <summary>
/// 合并两个datatable的内容
/// </summary>
/// <param name="DataTable_A">第一个datatable的ID</param>
/// <param name="DataTable_B">第二个datatable的ID</param>
/// <param name="DTName">新datatable的ID</param>
/// <returns>新datatable</returns>
private DataTable HeBin(DataTable DataTable_A, DataTable DataTable_B, string DTName)
{
    //最后合并成的datatable为DataTable_R
    DataTable DataTable_R = DataTable_A.Clone();

    //将DataTable_B的列名复制给DataTable_R
    for (int i = 0; i < DataTable_B.Columns.Count; i++)
    {
        DataTable_R.Columns.Add(DataTable_B.Columns[i].ColumnName);
    }

    //中转数据
    object[] obj = new object[DataTable_R.Columns.Count];

    //将DataTable_A的行赋给DataTable_R,这样DataTable_R就有了DataTable_A的数据
    for (int i = 0; i < DataTable_A.Rows.Count; i++)
    {
        DataTable_A.Rows[i].ItemArray.CopyTo(obj, 0);
        DataTable_R.Rows.Add(obj);
    }

    //如果此时DataTable_R的行数据已经比DataTable_B大了，就直接添加
    if (DataTable_A.Rows.Count >= DataTable_B.Rows.Count)
    {
        for (int i = 0; i < DataTable_B.Rows.Count; i++)
        {
            for (int j = 0; j < DataTable_B.Columns.Count; j++)
            {
                DataTable_R.Rows[i][j + DataTable_A.Columns.Count] = DataTable_B.Rows[i][j].ToString();
            }
        }
    }
    else
    {
        //否则只能新建空行再往里添加
        DataRow dr3;
        for (int i = 0; i < DataTable_B.Rows.Count - DataTable_A.Rows.Count; i++)
        {
            dr3 = DataTable_R.NewRow();
            DataTable_R.Rows.Add(dr3);
        }
        for (int i = 0; i < DataTable_B.Rows.Count; i++)
        {
            for (int j = 0; j < DataTable_B.Columns.Count; j++)
            {
                DataTable_R.Rows[i][j + DataTable_A.Columns.Count] = DataTable_B.Rows[i][j].ToString();
            }
        }
    }
    if (DTName != null)
    {
        DataTable_R.TableName = DTName; //设置DT的名字
    }
    return DataTable_R;
}

DataTable_A.Clone()这句话并不能直接克隆数据,所以一个简单的事,搞得复杂了.