I have 2 datatables and want to match rows of a particular column of one datatable to another datatable and depending on that result, I want to update one datatable using values from another datatble. I have done this using 2 for each loop and an if statement. I am attaching a screenshot of the same. Please help mw with this linq because using for each is taking much time because my dataset is huge.
Here i want to check column “CONCAT1” of DT_Uploading and “CONCAT” of RTGS_Master_Sheet and depending of the search, i want to update values in DT_Uploading with respect to RTGS_Master_Sheet.