I'm trying to create a report to show a group of orders with detail.
I have a stored procedure that pulls order detail within a date range for a customer.
I want to subtotal each Purchase Order of the individual items on the orders, break move on to the next order subtotal and then it would run...
I would like to connect Form Parameter in SQLDataSource to form. I would like to pass from form input box to form parameter in sql datasource to call stored procedure by date. How do I do that?
I have following code, how do I pass parameters from text box to the form parameters in sqldatasource?
<form id="Form1" action="Report.aspx" method=post target=_blank>
<asp:TextBox ID="TextBox1" runat="server" ></asp:TextBox> <br />
<asp:TextBox ID="TextBox2" runat="server"...
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.
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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.