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...
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 ...
How to check for the column name in an SqlDataReader Object in C# ?
When working in ADO.NET for data access , there are times when you want to check to see if a column ...