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


x

Interesting BlogPosts to read

Passing Array of Integers to ASP.NET Web API REST Service
You can pass an array of integer to an ASP.NET Web Web API REST service by setting the [FromUri] att...
Free Voice and Data benefits under JIO WELCOME OFFER to continue till 31st December 2016
Reliance Jio Infocomm Limited (“RJIL”) has received communication from Telecom Regulatory Authority ...
How to get an Enumerator from range of elements from ArrayList in C# ?
The code snippet shown in this blog post demonstrates how you can get the enumeraor from a range of ...