Empty value is showing true

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


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()


1 Like

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