response.write one data item on page

hi'
I'm new to c# (asp classic user) and all I want to do is display one database entry on a page.
I've used the SELECT command to get the data from table customers where id = 1
if the customers surname = smith then I want to display it with a response.write command.
in asp I would create a recordset and write response.write (=rs("username")
how do I do this in c# asp.net (website) please
thanks