Home>

For data stored in Datatable
I want to get the rows (number of records) that meet the condition.

Learn more

I want to do "COUNT" in sql.

If i have the following table

No name Age
0001 | Sato | 21
0002 | Kato | 32
0003 | Fujita | 29
0004 | Sasaki | 33
0005 | Takahashi 3 | 42

SELECT COUNT (*) AS count
FROM Employee Master
WHERE name lke'% wisteria%'

is the number of data with a wisteria in "name"
I think you can get it.

I want to achieve this with DataTabele.

Supplemental information (FW/tool version etc.)

VB.NET
VisualStudio2015