C# .. DataTable Merge

[Patric]

Hello

I am trying to combine different DataTables.
DataTable--1 ==> Matrix : 3row * 4column ==> DataTable is created.

DataTable--2 ===> Matrix : 3row * 4column ==> DataTable is created.

I don't know how to join the different DataTable--1 and DataTable--2 that have been created.
===> Matrix : 3row * 8column

===> How do you join DataTables in C#?

Awaiting your reply.
Thank you

 

[VBService]

Did you try use DataTable.Merge method?
Something like this way e.g.

using System;
using System.Data;

namespace ConsoleApplication1
{
    class Program
    {
        static void Main(string[] args)
        {
            DataTable dataTable1 = new DataTable();
            dataTable1.Columns.Add("Name", typeof(string));
            dataTable1.Columns.Add("Age", typeof(int));
            dataTable1.Columns.Add("School", typeof(string));

            dataTable1.Rows.Add("Alex", 21, "Princeton");
            dataTable1.Rows.Add("James", 24, "Harvard");
            dataTable1.Rows.Add("Kevin", 23, "Yale");

            DataTable dataTable2 = new DataTable();
            dataTable2.Columns.Add("Name", typeof(string));
            dataTable2.Columns.Add("Age", typeof(int));
            dataTable2.Columns.Add("School", typeof(string));

            dataTable2.Rows.Add("Joel", 20, "Columbia");
            dataTable2.Rows.Add("Gregory", 25, "Stanford");
            dataTable2.Rows.Add("Henry", 22, "California");


            // Merge dataTable2 into dataTable1
            dataTable1.Merge(dataTable2);

            // Display the merged DataTable
            foreach (DataColumn column in dataTable1.Columns)
                Console.Write(column.ColumnName + "\t\t");

            Console.WriteLine("\n" + (new string('-', 45)));

            foreach (DataRow row in dataTable1.Rows) {
                foreach (var item in row.ItemArray)
                    Console.Write(item + "\t\t");
                Console.WriteLine();
            }

            Console.ReadKey();
        }
    }
}