I have 2 sample Data Tables.
The objective is to find the rows from dt2 to dt1. If there are no discrepancies, it passes (written in col-4 of dt1).
EDIT: I forgot to add screenshots my bad.
dt1 looks like this
dt2 looks like this
Is it possible to use dt1.Rows.IndexOf() using dt2.Select as a parameter?
Any solution is much appreciated.
Use Datable .Select(“[Col1]<>‘’ or [Col-2]<>‘’ or [Col-3]=‘test’”).CopyToDatatable
and then use build data table and add columns and bind the data by using add data row