bind stored procedure

[nastenka]

bind stored procedure with html form or with textbox - how do I do that?

 

[jbenson001]

what version of .NET are you using?

 

[nastenka]

I am using .NET version 2, Visual Studio 2005 version 8. The parameter that I am passing is a date, if that matters.

 

[jbenson001]

I am confused as to what your question is now. Do you want to bind a value returned from your sql to a textbox, or use the textbox as an input parameter?

 

[nastenka]

I want to use textbox as input parameter, and to pull up from stored procedure the information bounded by the two textboxes, bounded by the input in these input pararameters, particulary - a date.

 

[jbenson001]

I belive with 2.0 you can modify the sqldatasource to use parameters from a number of objects, session variables etc.

 

[nastenka]

The thing is that I want to show a part of procedure on screen that is between the two dates entered, can a session do that?

 

[nastenka]

I use <formparameters> in sql, but I am not sure how to call the <formparameters> from text box or form. I know form can have action="<%= response.something %> , but I have never used it and not sure what is the syntax.