Only displays unique values in a combo box.

Contributed by
Rating: 3 stars3 stars3 stars3 stars3 stars / 3
February 08, 2000
Rate this Article:
MEH MEH++


SEARCH ASP FREE
TOOLS YOU CAN USE

advertisement

Unique combo box sample



Here is the code for this Example

<%@ Language=VBScript %>
<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
</HEAD>
<title>Unique combo box sample</title>
<BODY>
<!-- Author: Adrian Forbes -->
<%
set objRS = createobject("ADODB.Recordset")
objRS.Open "select strParent from Parent", strconn
set objDic = CreateObject("Scripting.Dictionary")
while not objRS.EOF
    sString = cStr(objRS("strParent"))
    if not objdic.Exists (sString) then
        objDic.Add sString, sString
    end if
    objRS.MoveNext
wend
objRS.Close
set objRS.ActiveConnection = nothing
set objRS = nothing
%>
<form name=frmTest action="TwoComboDatabase.asp" method=POST>
<p>
<select name=cboPrimary size=1>
<%
aResults = objDic.Items
for i = 0 to objDic.Count - 1%>
<option><%=aResults(i)%>
<%next
objDic.RemoveAll
set objDic = nothing
%>
</select>
</p>
</form>
</BODY>
</HTML>

blog comments powered by Disqus
ASP CODE ARTICLES

- ASP Forms
- ASP: The Beginning
- Getting Remote Files With ASP Continued
- Inbox and Outbox Manipulation in ASP
- Relational DropDownList Using VB.NET
- Ad Tracking URL Hits
- Use ViewState to display one record per page...
- Send Email using ASP.NET formatted in HTML
- ASP File Explorer
- ASP/XML Interview questions by Srivatsan Sri...
- Pressing RETURN won't submit the form
- This shows how you get the TEXT of a combo r...
- Group Data by Adrian Forbes
- Multiple checkbox select sample
- Multiple checkbox select with all values sam...

ASP Web Hosting ASP.Net Web Hosting Windows Web Hosting
 
 
 

ASP Free Forums 
 RSS  Tutorials RSS
 RSS  Forums RSS
 RSS  All Feeds
Site Map 
Request Media Kit
Write For Us Get Paid 
Weekly Newsletter
 
Developer Updates  
Free Website Content 
Privacy Policy 
Support 


© 2003-2012 by Developer Shed. All rights reserved. DS Cluster 11 - Follow our Sitemap
Most Popular Topics
All ASP.Net Tutorials