Datatable Compare for Checking Rows Exist and a Condition is true for further process

@Prateek_Gulab_Pathak ,

It seems that there are empty row values in your Datatables, Could you check by first performing the update of the Datatable with the below Expression :

OutputDT = OutputDT.AsEnumerable.Where(Function(x)Not x.ItemArray.All(Function(y)String.IsNullOrWhiteSpace(y.ToString.Trim))).CopyToDatatable

You could then check the condition provided previously :

1 Like