SQL Sever SELECT to asp.net webpage

[saetiagous]

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!!

 

[sloan]

Are you displaying 1 Name/Job combo, or are you display 10,20, (N Number) of
Name/Jobs?

 

[saetiagous]

It is as two seperate N-number name and job columns.

e..g

NAME JOB
Paul cleaner
Peter swimmer
Mike programmmer

Then on my site, i would like to them to be displayed in tetxt boxes
like:

Paul
cleaner


Peter
swimmer

Mike
programmer

 

[sloan]

Start Here:
http://www.aspnettutorials.com/tutorials/database/db-storedprocs-aspnet2-vb.aspx



Work thru that. and you should be able to get a textbox populated.

Also consider the <asp:Label>