Check for empty cell in a datatable

Learn Academy Feedback
1

How do i check for an empty field from a datatable? Using linq instead of for each row/column. the datatable should be fully filled. Not a single blank item.

2

@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
3

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