I want to query an SQL table for all instances of a particular field. (i.e. SELECT COUNT(*) FROM myTable where ID = '187')
Then I want to cycle through each record and do something based on the data. (For Each, EOF/BOF, etc.)
What is the best way to go about doing this in ASP.NET(VB)?