c# - 如何将两个相同列的数据表单元格合并到一个单元格中，用 C# 分隔逗号？

Question

我有两个具有相同列的数据表，例如：-

输入数据表1

Column1   Column2     Column3
--------------------------
Aa         Bb          Cc
Dd         Ee          Ff

输入数据表2：

Column1  Column2      Column3
-----------------------------
  Gg         Hh        Ii
  Jj         Kk        Ll

我需要这样的输出：

Column1          Column2           Column3
------------------------------------------
Aa,Gg             Bb,Hh             Cc,Ii
Dd,Jj             Ee,Kk             Ff,Li

提前感谢您的帮助！

标签： c#.net

Answer 1

DataTable dataTable1 = new DataTable();
        DataTable dataTable2 = new DataTable();
        dataTable1.Columns.Add("Column1", typeof(string));
        dataTable1.Columns.Add("Column2", typeof(string));
        dataTable1.Columns.Add("Column3", typeof(string));
        dataTable2.Columns.Add("Column1", typeof(string));
        dataTable2.Columns.Add("Column2", typeof(string));
        dataTable2.Columns.Add("Column3", typeof(string));
        dataTable1.Rows.Add("Aa", "Bb", "Cc");
        dataTable1.Rows.Add("Dd", "Ee", "Ff");
        dataTable2.Rows.Add("Gg", "Hh", "Ii");
        dataTable2.Rows.Add("Jj", "Kk", "Ll");

        Console.WriteLine("Column1  Column2 Column3");
        for (int i = 0; i < dataTable1.Rows.Count; i++)
        {
            Console.Write("\n"+dataTable1.Rows[i]["Column1"].ToString()+","+ dataTable2.Rows[i]["Column1"].ToString());
            Console.Write("\t" + dataTable1.Rows[i]["Column2"].ToString() + "," + dataTable2.Rows[i]["Column2"].ToString());
            Console.Write("\t" + dataTable1.Rows[i]["Column3"].ToString() + "," + dataTable2.Rows[i]["Column3"].ToString());
        }
        Console.ReadKey();