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)

If you enjoyed this post, please consider leaving a comment or subscribing to the RSS feed to have future articles delivered to your feed reader.

Leave a Reply