Datatable value comparison

Help Activities
,
1

I have two tables. I have to compare values of both table. If values are different or blank,I need to capture it in another table. How to do?Please help

2

I think u can try the below linq query
dt3 = dt1.AsEnumerable().Except(dt2.AsEnumerable(),System.Data.DataRowComparer.Default).CopyToDataTable

It will fetch the uncommon rows from the datatable

Regards

Nived N

Happy Automation

3

Hi Nived,

I dont have to use LinQ in my code. Is there any other way

4

Hi @Sana_Afreen

Can u Share the screenshot of the datatable u nee as output ?