Using ADO.NET - I think!?

Hi

I've added a text box and button to my page. When the user clicks the button, I would like to take the value entered into the text box and using code behind, search my database like this:

SELECT ClientName, WebID FROM tblGalleryAccess WHERE ID = (the value in the text box).

There will only be one row of data returned, and with that, I've like to create 2 variables which store the values of ClientName and WebID based on the returned values of the SQL string.

 I'm using C# 3.5 - Can any one help?

Many thanks
Richard
...