text box values as parameters in Stored Procedures??? - TechRepublic
Question
January 5, 2007 at 04:59 PM
nuskool

text box values as parameters in Stored Procedures???

by nuskool . Updated 19 years, 6 months ago

Hello,

I am using asp.net in Visual Studio 2005. I am trying to get a value from a text box to use as the parameter in a stored procedure. The stored procedure would run and then display the results in the next page. I have googled and checked forums but can not find any examples of how to do this.

I can get a dropdown list to be databound to the grid on the same page but I would like to have a user put in a value click submit and then taken to the next page showing the results. I have tried many different methods but nothing seems to work.

I have for example tried to put ASP tags inside the generated stored procedure statement. tried to use a combo list and then change the name to that of the text box. tried to put the sql inside the submit click event, but no luck.

This is the hardest part of the project for me because I can not find any examples.Any help or direction would be appreciated whether it is links, sample code, the needed logic. Anything.

Thanks in advance.

P.S. I am not a professional programmer. I am a Network Administrator who was thrown into this position and the project is almost done except for this one part.

This discussion is locked

All Comments