SQL Select statement results to asp.net webpage

[saetiagous@googlemail.com]

Hi,

I have a stored procedure in SQL Sever which retrieves 2 columns, NAME
and JOB, using a simple statement (SELECT Name, Job FROM People).

I wanted to know, how do i put the values of these 2 columns into 2
seperate textBox on my asp.net webpage?

I can make a connection to the stored proedure but don't know how to
'accept' and use the values i get from my SQL statement.

Any help would be much appreciated, Cheers
Tiago!!