I am using one drop down in html and the value is coming from database in dropdown option. I want to add all option in single form how to concatenate all option in single form please describe?
<select id="Services">
<%
While not rsMI.EOF
%>
<option>--- Select Value.---</option>
<OPTION VALUE="<%=rsMI("HOUSE_NUMBER")%>"><%=rsMI("HOUSE_NUMBER")%></OPTION>
<OPTION VALUE="<%=rsMI("PREFIX_DIRECTIONAL")%>"><%=rsMI("PREFIX_DIRECTIONAL")%></OPTION>
<OPTION VALUE="<%=rsMI("HOUSE_NUMBER_SUFFIX")%>"><%=rsMI("HOUSE_NUMBER_SUFFIX")%></OPTION>
<OPTION VALUE="<%=rsMI("STREET_NAME")%>"><%=rsMI("STREET_NAME")%></OPTION>
<OPTION VALUE="<%=rsMI("STREET_SUFFIX")%>"><%=rsMI("STREET_SUFFIX")%></OPTION>
<OPTION VALUE="<%=rsMI("POST_DIRECTIONAL")%>"><%=rsMI("POST_DIRECTIONAL")%></OPTION>
<%
rsMI.MoveNext
Wend
Set rsMI= nothing
%>
</select>