Update database in ASP

[smita86]

hello to all, i am making an application in asp.I have two combo box ..now suppose i save selected item from two combo in the database..

now i want that when i click on update button the two combox box should come with that saved selected value along all the another values also..

Can anyone help me please???

[ulthane]

do u mean something like this?

<select name="options">
<option value="opt1"
if RS("something") = "opt1" then
selected="selected">
end if
opt1</option>
...
</select>

[smita86]

i have taken the combo box data from a table. I have made the below code.Please guide how to change the below data.

<% SQL ="Select City From City order By City"
Set rs = sconn.Execute(SQL)%>
<select name="Location" size="1">
<option >- Select -</option>
<%while not rs.EOF%>
<option value=<%=rs(0)%>><%=rs(0)%></option>
<%RS.MoveNext
wend%>
</select>

[awasson]

i have taken the combo box data from a table. I have made the below code.Please guide how to change the below data.

<% SQL ="Select City From City order By City"
Set rs = sconn.Execute(SQL)%>
<select name="Location" size="1">
<option >- Select -</option>
<%while not rs.EOF%>
<option value=<%=rs(0)%>><%=rs(0)%></option>
<%RS.MoveNext
wend%>
</select>

Well ulthane has provided the conditional logic to do the trick but we need to know which city we are viewing... Have you passed that through a querystring argument or is it an ID that we pull from the database?

Assuming we know what city we are viewing and put that value in a variable called varCity You need to use it in your code as follows:

<%
    varCity = 'The city we're looking at
    varSelected = "" 'This is just the string we use to bookmark the drop down
%>

<%while not rs.EOF%>
<%
    if varCity = rs(0) then
        varSelected = "selected = ""selected"""
    end if
%>
        <option <%=varSelected%> value=<%=rs(0)%>><%=rs(0)%></option>
        <%
   varSelected = ""
   RS.MoveNext             
    wend
%>