Extract the missing rows in a table by comparing it with an existing table

[vidyasak (Sagar)]

From the two tables , I want to compare the blue table with the yellow one and extract the missing rows. How to do that?

[Shiva_Nikhil]

@vidyasak

You can try this

dt1.AsEnumerable.except(Dt2.AsEnumerable,system.data.datarowcomparer.default).CopyToDataTable

Here dt1 is the yellow datatable

And dt2 is the blue datatable

[vidyasak (Sagar)]

Thanks Shiva. It worked.