Empty value is showing true

Help Something Else
1

image
image1340×801 58.9 KB

hi just wanna ask.
this is comparing 2 id(s) from dt1 and dt2
and if the id is true then the condition will happen . my problem is even the column id is empty or null is shows true

2

Hi,

As empty string is not same as null, it’s necessary to exclude case of empty string.

Can you try the following expression, for example? This also filters out row which has empty string in column 3 of MSEDT.

FindRow = MSEDT.AsEnumerable.Where(Function(x) x(3).ToString.Equals(CurrentRow(9).ToString) AndAlso (not String.IsNullOrEmpty(x(3).ToString))).FirstOrDefault()

Regards,

1 Like
3

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