Compare Two Datatable and get only Unique(New) Data from DT2

Hi

Compare Two Datatable (DT1 and DT2) and get only Unique(New) Data from DT2
.
Thanks
Vishal

Hi,

How about the following expression?

dt2 = dt2.AsEnumerable.Except(dt1.AsEnumerable,DataRowComparer.Default).CopyToDataTable

Regards,

@Yoichi Thank you for help.

I have another question is
I want to Check on Specific Column. So How can I do

Thank You
Vishal

Hi @Vishal_Prajapati

Can you explain it with a sample input and output