Linq query to compare 2 datatable and get matching rows

[divya_Bhat]

Hi All,

I have 2 datatable
DT1 :
Name Role
AAA IT
BBB Customer Executive

DT2 :
Name Role
AAA IT
CCC Admin
BBB Customer Executive

I need to retrieve matching records

Final result :
Name Role
AAA IT
BBB Customer Executive

[pavithra_pavi (Pavithra Bhat)]

Hi @divya_Bhat , firstly welcome!.

After reading your question, here is the code. Use Intersect it will get the require common rows

dt1.AsEnumerable().Intersect(dt2.AsEnumerable(),System.Data.DataRowComparer.Default).CopyToDataTable

[divya_Bhat]

@pavithra_pavi for quick help!, i was in need of urgent help. Code works !!!

[pavithra_pavi (Pavithra Bhat)]

@divya_Bhat , happy to help!