How To Merge Two DataTables Into One Using C#

Let's create a project and name it Demo. Write the following code in default.aspx.cs.

DataTable dt = new DataTable("Order");
DataColumn dc = dt.Columns.Add("ID", typeof(int));
dt.Columns.Add("Name", typeof(String));

dt.Rows.Add(1, "pramod");
dt.Rows.Add(2, "ravi");
dt.Rows.Add(3, "deepak");
dt.Rows.Add(4, "kiran");
dt.Rows.Add(5, "madhu")

Set a breakpoint on line dt.Rows.Add(5,”madhu”) and hit F5. Mouseover on dt and then click on the arrow icon and you will get the following screen.



After clicking on DataTable visualizer you will get this.

Output



Now create another datatable.

DataTable dt2 = new DataTable(“Order”);
DataColumn dc2 = dt2.Columns.Add(“ID”, typeof(int));
dt2.Columns.Add(“Name”, typeof(String));
dt2.Columns.Add(“Type”, typeof(String));

dt2.Rows.Add(6, “ashu”,”Gen”);
dt2.Rows.Add(7, “rudra”, “Gen”);
dt2.Rows.Add(8, “kavita”, “Gen”);
dt2.Rows.Add(9, “suman”, “Gen”);
dt2.Rows.Add(10, “lakshman”, “Gen”);

Set a BreakPoint on line dt2.Rows.Add(10, “lakshman”, “Gen”) and hit F5.

Output

// Add both datatable in single datatable.
dt.Merge(dt2);

Output



I hope you enjoy this article.

Happy coding.