I have a column which is of having 25 rows contains values and empty spaces. Now I need to return the count of the column which has only values.
Hi @agathiyanv
Try this please.
dt.AsEnumerable().Where(Function(row) Not String.IsNullOrWhiteSpace(row(“Column1”).ToString)).CopyToDataTable.RowCount
count is a int32 variable
dt is a name of datatable
Column1 is a name of the column
2 Likes
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.