Cloud Training (Online)




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)
{
            EmployeeDataTable1.Merge(EmployeeDataTable2);
}

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