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

Hi @divya_Bhat , firstly welcome!. After reading your question, here is the code. Use Intersect it will get the require common rows [image] dt1.AsEnumerable().Intersect(dt2.AsEnumerable(),System.Data.DataRowComparer.Default).CopyToDataTable

Linq query to compare 2 datatable and get matching rows

Help Studio

pavithra_pavi (Pavithra Bhat) October 10, 2022, 6:21am 4

@divya_Bhat , happy to help!

Topic		Replies	Views
Linq query to compare two datatable and return values Studio activities , question	5	793	October 10, 2023
How to find common rows between two datatables using LINQ? Studio studio , question , project_panel	6	1535	October 19, 2023
Compare two datatables and get mismatched records Academy Feedback datatable , activities , question	6	3361	March 6, 2020
How to compare two datatable remove duplicate using Linq Studio lp_developer_fnd	2	2828	April 19, 2021
Get the Matching rows When DT1 compared to DT2 Studio datatable , excel , studio , question , activities_panel , linq	8	1313	July 19, 2022

Linq query to compare 2 datatable and get matching rows

Related topics