If you're only returning one row, use a stored procedure with output parameters for the values you are fetching. This will be faster than using a recordset and will leave you with instantiated command parameters that you can use in HTML.

--Jonathan