|
Subject:
|
Textbox
|
|
Posted By:
|
deontae45
|
Post Date:
|
9/25/2006 8:50:02 AM
|
How can I run a stored procedure and get that value to display in a textbox? I can get it to show in a datagrid by using:
grdConsumer.DataSource = cmdNextSpecialist.ExecuteReader()
grdConsumer.DataBind()
How do I get it to display in a textbox? I'm not passing through any parameters. It automatic runs when the page is open.
Alexander Nelson
Programmer
|
|
Reply By:
|
dparsons
|
Reply Date:
|
9/25/2006 11:26:21 AM
|
You can use Output Parameters and set the value of the text box to the that of the output parameter;
You could create a datareader object and loop through your returned result set ala:
While objdataReader.read
'Do something with the data
End While
You could bind the resultset to a memory resident datatable and loop through that datatable like this:
for each datarow in datatable.rows
'Do something with the data
next
hth.
--Stole this from a moderator
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.
|
