Check for empty cell in a datatable

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.

@TyraS - Please try this…

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

Assign the above statement to Boolean variable…


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