Count rows from specific column and specific values in datatable

[Lior_Ben_Naim]

hey,

I need help counting the number of rows with a specific value from a specific column in datatable
for example

i need to count how many ‘None’ Value i have in column ‘Item’

[johnfelix (John Felix Yesuraj)]

You can try this query to get the count

dt.Select(“[Item]=‘None’”).CopyToDataTable.Rows.Count

or this if you want to perform string operations

dt.AsEnumerable().Where(Function(s) s(“Item”).ToString.Trim.Equals(“None”,StringComparison.OrdinalIgnoreCase)).CopyToDataTable.Rows.Count.ToString

Thanks
John