How to check if datatable is empty or not?

[Sanket_Shinde1 (Sanket Shinde)]

Hi , When I scrap empty data table then I check it is empty or not
but it return false even if the datatable is blank

See the image

I want condition return true when dt is blank

[Anil_G (Anil Gorthi)]

@Sanket_Shinde1

Use this

dt.AsEnumerable.All(function(x) x.ItemArray.All(function(y) String.IsNullOrEmpty(y)))

cheers

[Sanket_Shinde1 (Sanket Shinde)]

@Anil_G

dt.AsEnumerable.All(function(x) x.ItemArray.All(function(y) String.IsNullOrEmpty(y)))

I have to paste if condition?

[Sanket_Shinde1 (Sanket Shinde)]

I have paste is if condtion then get this error

[Anil_G (Anil Gorthi)]

@Sanket_Shinde1

Yes exactly

cheers

[Anil_G (Anil Gorthi)]

@Sanket_Shinde1

A small correction

IsNothing(dt) OrElse dt.AsEnumerable.All(function(x) x.ItemArray.All(function(y) String.IsNullOrEmpty(y.ToString)))

cheers

[Sanket_Shinde1 (Sanket Shinde)]

It works!!!
thank you so much Anil