Home | Quizes | Downloads | Tech Terms | Tutorials | News | Forum | Site Map | Feedback

ASP Code Samples

Dynamic drop down list(eg. 1999 - xxxx)

This is very useful when you want to access a list saved in a database. The good thing about this is that when you change your values in the database, it automatically shows up on the form.

Example. Create a sample database called Data.mdb

Field Attribute Length
Id AutoNumber  
Choice Text  
     

<select name="choice">
<% while not oRs.EOF %>
                   
<option value="<%= oRs("
choice")%>"><%= oRs("choice")%>
</option>
<%
oRs.
moveNext
wend
%>
</select>

Select Choice

 


I hope you found this interesting enough. If you have any suggestions, please post it to the Tech Forum or send us your Feedback

 

 



  
2004 Emefa Amenuvor [i][m][f][t][e][c][h] all rights reserved