Retrive values to Drop down list from DB when Back
Hi guys,
On a form i have dropdown lists, when selected and the continue button is pressed the values from dropdown are inserted on to the database. On the next web page i have a back button, if pressed it goes to the previous page (Form 1) with requesting the id that was submitted from the DB.
I now also want to retrive what was selected on the dropdown list to show up when the back button is pressed. So if Yes was selected and passed, the DB will insert the value true. When i press the back button that Yes will need to load on theat drop down list.
Can someone help me on how i could do this.
The continue button:
Response.Redirect("showtable.aspx?tid=" & tmid & "&pc=" & strPostCode)
The Back Button:
Private Sub btnback_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnback.Click
Response.Redirect("TelephoneUsage.aspx?tid=" & TM.TelephoneInputFormID & "&pc=" & strPostCode)
End Sub
these are getting inserted into the database:
With Signup
.TelephoneCallPlanID = numberofcalls.SelectedItem.Value
.TelephoneUsageTimeID = whencallsaremade.SelectedItem.Value
.TelephoneUsageLocationID = wherecallsaremade.SelectedItem.Value
.SpecificMobileNetworks = callstomobile.SelectedItem.Value
.TelephoneCallsPerDayID = numberofcalls.SelectedItem.Value
.InternationalCalls = callstointernational.SelectedItem.Value
End With
when the back button is pressed these needs to be retrived back on the drop down list.
Thanks
Mac
|