Discuss "Creating Dynamic Dropdown Menu!?" in the ASP Development forum.

jarvelous · #1 March 20th, 2008, 12:26 PM

Hi everyone. I am new to ASP and am wanting to create a drop down menu. I have a table in my database called 'members'. I want to show all members in the drop down.

My field names that I need to populate the drop down table with are:

- MemberID (Value to pass)
- MemberName (Option to be displayed)

Can you please tell me how to create a drop down?

Thanks!!
jarvelous

BLaaaaaaaaaarche · #2 March 20th, 2008, 12:30 PM

Hey jarvelous, welcome to the DeveloperBarn forums! To create a dynamic drop down menu, you first need to create a recordset to your DB. You can do this like so:

Code:

strSQL = "SELECT MemberID, MemberName FROM members ORDER BY MemberName"
Set objRS = siteConn.Execute(strSQL)

After you have created your recordset, you will want to loop through the recordset:

Code:

response.write "<select name=""Members"">" & vbCrLf
response.write "<option value="""">Select Member</option>"
Do While Not objRS.EOF
	response.write "<option value=""" & objRS("MemberID") & """>" & objRS("MemberID") & "</option>" & vbCrLf
objRS.MoveNext
Loop
response.write "</select>" & vbCrLf

You will also want to make sure you close your connection after your are done. Do so like so:

Code:

objRS.Close
Set objRS = Nothing

Hope this helps. Let us know if you need any additional help.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Dynamic dropdown list with multiple records	Rebelle	ASP Development	4	April 30th, 2008 05:33 AM
[ASP.Net/VB.Net] VB.Net Dynamic Recursive Menu	jmurrayhead	Code Samples	0	March 18th, 2008 10:47 AM

Discuss "Creating Dynamic Dropdown Menu!?" in the ASP Development forum.

ASP Development - Learn coding practices and tips to get the best out of your Active Server Pages (ASP). The Classic ASP forum is for ASP/VBScript and ASP/JScript applications.