Firoj Ali
Firoj Ali

Reputation: 1

How to make a relation between data table in data set

I have one data set DS1. In this data set have two data tables: DT1 and DT2 The layout of the data ables looks like this:

DT1 Data:

**ID  Name**
   1  Amit
   2  Alok
   3  Munish

DT2 Data:

**ID  Name**
   2  Alok
   3  Munish
   4  Firoj

I want to create a new table that looks like:

**ID  Name**
   2  Alok
   3  Munish

Upvotes: 0

Views: 180

Answers (1)

Chris Dargis
Chris Dargis

Reputation: 6043

The DataTable class has a Merge method:

DataTable DT1;
DataTable DT2;
DT1.Merge(DT2);

DataTable.Merge

Upvotes: 2

Related Questions