SQL Sever SELECT to asp.net webpage

  • Thread starter Thread starter saetiagous
  • Start date Start date
S

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!!
 
Are you displaying 1 Name/Job combo, or are you display 10,20, (N Number) of
Name/Jobs?
 
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
 
Back
Top