Updating column based on another dt Column with LINQ

I would like to update column “Description” with “Desc” column from dtSample2 knowing I can refer to the same Business Partner code column. The keys column can be in any order and they can be repeated for dtSample1. dtSample2 has just one record for Business Partner and it’s mine master data.
Can you please give me the statement to perform that ? I’ve always used LINQ for filtering and I woul dlike to avoid for each … Thanks.


The straight forward and easy way would be to use join datatable and then use filter datatable to remove the non required columns


1 Like

Thanks Anil, that’s worked!

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.