Updating column based on another dt Column with LINQ

[Meli_Marco]

Hello,
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.

[Anil_G (Anil Gorthi)]

@Meli_Marco

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

Cheers

[Meli_Marco]

Thanks Anil, that’s worked!