LINQ update DataTable status based on comparison between two DataTables

Help Activities
, ,
1

Hi everyone, could you help me with something? I have two tables, dt_SAP and dt_BaseDrive. Dt_SAP has the pending order records and dt_BaseDrive has the entire order history. Dt_BaseDrive has a column called Status, and both tables have a column called Document. The condition is that if the data in the Document column of dt_BaseDrive is not in the Document column of dt_SAP, the status should change to Delivered in dt_BaseDrive. How can I do this with Linq?

2

Hi @Juan_Esteban_Valencia

Can you try the below code

image

For Each rowBaseDrive As DataRow In dt_BaseDrive.Rows
    Dim documentExists As Boolean = dt_SAP.AsEnumerable().Any(Function(sapRow) sapRow("Document").ToString() = rowBaseDrive("Document").ToString())
    
    If Not documentExists Then
        rowBaseDrive("Status") = "Delivered"
    End If
Next

The image shows a dialog box for "Invoked code arguments" with two data table arguments, "dt_BaseDrive" and "dt_SAP", specifying their direction, type, and value. (Captioned by AI)
The image shows a dialog box for "Invoked code arguments" with two data table arguments, "dt_BaseDrive" and "dt_SAP", specifying their direction, type, and value. (Captioned by AI)878×256 10.4 KB

Regards,

3

Perfect! Thank you very much for your help.

1 Like
4

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