I have two excel files. In excel 1 (datatable : dt1) I have columns for City_Code and State_Name but data present only in City_Code. In another excel
(datatable:" dt2) I have column City_Code and Stata_Name and data present in both column city_code and State_Name. I want to write data in dt1.State_Name where
dt1.City_Code matches with dt2.City_Code.
I Don’t want to use for each loop. Can someone please provide LINQ query to achieve the result?
Please have a look at below excel screenshot.