C#如何将两个DataTable行合并为一行

DataTable mergedTable = new DataTable();

if (table1.Columns.Count != table2.Columns.Count)
{
    throw new Exception("两个DataTable的列数不一致");
}

for (int i = 0; i < table1.Columns.Count; i++)
{
    if (table1.Columns[i].ColumnName != table2.Columns[i].ColumnName)
    {
        throw new Exception("两个DataTable的列名不一致");
    }
    
    mergedTable.Columns.Add(table1.Columns[i].ColumnName);
}

for (int i = 0; i < table1.Rows.Count; i++)
{
    DataRow newRow = mergedTable.NewRow();
    
    for (int j = 0; j < table1.Columns.Count; j++)
    {
        newRow[j] = table1.Rows[i][j];
    }
    
    for (int j = 0; j < table2.Columns.Count; j++)
    {
        newRow[j + table1.Columns.Count] = table2.Rows[i][j];
    }
    
    mergedTable.Rows.Add(newRow);
}

foreach (DataRow row in mergedTable.Rows)
{
    foreach (DataColumn col in mergedTable.Columns)
    {
        Console.Write(row[col] + " ");
    }
    
    Console.WriteLine();
}