Merging DataTables by Primary Key

We often come across the need to merge DataTable.

In this blog, we are going to learn how to provide Primary Key to the DataTables and then merge them on the same basis.

DataTables with the following structure:

 

DataTable1:  

 

Source	Target	Name
4	1	Article
15	2	Blog
30	3	Code Snippet

 

DataTable2:

Target	Description
1	This is an article
2	This is a blog
3	This is a code snippet

 

We want the following output:

 

Final DataTable: 

Target	Source	Name	Description
1	4	Article	This is an article
2	15	Blog	This is a blog
3	30	Code Snippet	This is a code snippet

 

In order to do that, we provide Primary Key to the data tables in the following manner:

DataTable1.PrimaryKey = new DataColumn[] { DataTable1.Columns["TARGET"] };
DataTable2.PrimaryKey = new DataColumn[] { DataTable2.Columns["TARGET"] };
DataTable1.Merge(DataTable2);

Doing that you will get the required output in DataTable1.