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)

Leave A Reply

Your email address will not be published. Required fields are marked *

You May Also Like

C# Compiler Error CS0442 – ‘Property’: abstract properties cannot have private accessors Reason for the Error You’ll get this error...
This is a really simple one . Below is a simple example of an enum called “Designation” defined with the...
This blog post explain the usage of the Checked Block in .NET and how you can use them in Visual...