I have done so simple queries before with asp.net but I always bind all the results to a datagrid.

Is there a way to just get the results of a query into a int?

lets say I used a query like this:

SELECT MAX(Id) FROM Pubs

this should only return a single int, any idea how to just collect that and store it in an int?