Merge 2 DataTables in C# and ASP.NET

The Merge() method of the datatable is used to Merge a datatable (second datatable) and stores the result to the first datatable.

For example , assume the following datatables are present EmployeeDataTable1 and EmployeeDataTable2 .

If you want to merge the data from EmployeeDataTable2 to EmployeeDataTable1 , you could do something like below.

protected void Page_Load(object sender, EventArgs e)

When merging the datatable , verify if both the datatable contain the same columns and other constraints(if defined)