Concatenate drop down value in single form

Question

Hi

 

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>