Number Of Selected Rows

From a PHP background I could use mysql_num_rows() to get the number of selected rows from a SQL query. Looking through Google I can't see a way to do this with ASP.

One place I looked said you need to loop through all the selected fields and using an incrementing counter, which doesn't sound like a good idea :/

If this is the case (which I hope it isn't), is there any way like PHP which you can then tell the SQL object to go back to the begining so you can reloop it (if you catch my drift)?