neegreeType
New Member
I'm using dbNetSuite, a set of asp.net based tools for web development. I don't see many questions about dbNetSuite here on SO, but I'll give this a try anyway. I am fairly new to asp.net development, so apologies in advance if the question doesn't make sense or if the answer is obvious. dbNetSuite documentation gives this example:\[code\]<DNL
bNetGrid id="customersGrid" runat="server" ConnectionString = "SamplesDatabase" ProcedureName = "[Sales By Year]" Navigation = "false" RowInfo = "true" Caption = "Sales in March 1995" > <ProcedureParameters> <DNL
arameter Name="BeginningDate" Value="http://stackoverflow.com/questions/12784822/1-Mar-1995"/> <DNLarameter Name="EndingDate" Value="http://stackoverflow.com/questions/12784822/31-Mar-1995"/> </ProcedureParameters> <GridColumns> <DNL:GridColumn ColumnExpression="ShippedDate" Label="Shipped" Format="D"/> <DNL:GridColumn ColumnExpression="OrderID" Label="Order ID"/> <DNL:GridColumn ColumnExpression="SubTotal" Label="Value" Format="C"/> </GridColumns> </DNLbNetGrid>\[/code\]The ProcedureName property returns a data set from a SQL Server stored procedure. That part works fine. However, in the example above the parameter values are hard-coded in the web code. I want a user to be able to choose the dates then click a button to run the report. I'm using calendar widgets and the selected date ends up in a non-visible textbox, ready to be passed in as a parameter. The button is in code-behind, no problem there. But how do I pass the tb value in to the value of the ProcedureParameter?
bNetGrid id="customersGrid" runat="server" ConnectionString = "SamplesDatabase" ProcedureName = "[Sales By Year]" Navigation = "false" RowInfo = "true" Caption = "Sales in March 1995" > <ProcedureParameters> <DNLarameter Name="BeginningDate" Value="http://stackoverflow.com/questions/12784822/1-Mar-1995"/> <DNLarameter Name="EndingDate" Value="http://stackoverflow.com/questions/12784822/31-Mar-1995"/> </ProcedureParameters> <GridColumns> <DNL:GridColumn ColumnExpression="ShippedDate" Label="Shipped" Format="D"/> <DNL:GridColumn ColumnExpression="OrderID" Label="Order ID"/> <DNL:GridColumn ColumnExpression="SubTotal" Label="Value" Format="C"/> </GridColumns> </DNLbNetGrid>\[/code\]The ProcedureName property returns a data set from a SQL Server stored procedure. That part works fine. However, in the example above the parameter values are hard-coded in the web code. I want a user to be able to choose the dates then click a button to run the report. I'm using calendar widgets and the selected date ends up in a non-visible textbox, ready to be passed in as a parameter. The button is in code-behind, no problem there. But how do I pass the tb value in to the value of the ProcedureParameter?