Datatable value comparison

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

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


Nived N

Happy Automation

Hi Nived,

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

Hi @Sana_Afreen

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