Check for empty cell in a datatable

@TyraS - Please try this…

 (From d in dtData.AsEnumerable
 Let check = d.ItemArray.Any(Function (x) isNothing(x) OrElse 
 String.IsNullOrEmpty(x.toString.trim))
 Select check).Any(Function (e) e)

Assign the above statement to Boolean variable…

3 Likes