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

__________________
Alexander Nelson
Programmer

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.