How to compare 2 data tables and get only unique values

Hi All,

I will get input from database i will have to compare input from previous day report.
I need to compare "sales_order_id and Directory_Number columns in both tables
Same sale order can be present in both datatbles. But i have to take telephone numbers which is added new on input sheet only those.
Example
DT1

SALES_ORDER_ID DIRECTORY_NUMBER
182137069 8586497479
182137069 8586497480

DT2

SALES_ORDER_ID DIRECTORY_NUMBER
182137069 8586497479

Out Put:-

|182137069|8586497480|

I have tried with below link query but not getting records. Can some one help me on this.
out_strTnDt.AsEnumerable.Where(Function(x) Not previousdayReport.AsEnumerable.Any( Function(y) x(“SALES_ORDER_ID”).ToString.Trim.Equals(y(“SALES_ORDER_ID”).ToString.Trim))).Count > 0

Regards,
Hima

@thima,

Can you try below code?

var differences = dataTable1.AsEnumerable().Except(dataTable2.AsEnumerable(),DataRowComparer.Default);

Cheers,
Pankaj