Microsoft KB Archive/175426

= How To Populate a Combobox from Active Server Pages =

Article ID: 175426

Article Last Modified on 5/2/2006

-

APPLIES TO


 * Microsoft Active Server Pages 4.0
 * Microsoft Visual InterDev 1.0 Standard Edition
 * Microsoft Internet Information Server 4.0
 * Microsoft Internet Information Services 5.0
 * Microsoft Data Access Components 2.5
 * Microsoft Data Access Components 2.6
 * Microsoft Data Access Components 2.7

-



This article was previously published under Q175426



SUMMARY
This article demonstrates how to load a ComboBox with records that are retrieved from a database. This example creates an Active Server Pages (ASP) page that connects to the Adventure Works database.



MORE INFORMATION
The following code demonstrates how to load values into an HTML list box:   This is an HTML ListBox  <% Set conn = Server.CreateObject("ADODB.Connection") %> <% conn.Open "DSN=AdvWorks" ' connect to the database %> <% Set rs = conn.Execute("SELECT City FROM Customers") %> <% Do While Not rs.EOF ' define the ListBox OPTIONs %> "> <%= rs("City") %> <% rs.MoveNext %> <% Loop %> <% rs.Close %> <% conn.Close %>    The following code demonstrates how to load values into an ActiveX ComboBox control. Be aware that this control must be installed and registered on your system in order for this sample to work correctly: <%@ LANGUAGE="VBSCRIPT" %>   This is an ActiveX ComboBox control <OBJECT ID="ComboBox" WIDTH=96 HEIGHT=24 CLASSID="CLSID:8BD21D30-EC42-11CE-9E0D-00AA006002F3"> </OBJECT> <SCRIPT LANGUAGE="VBScript"> </SCRIPT> </BODY> </HTML> NOTE: Use your browser to view these pages and the view the HTML source. This will give you a better understanding of what code was produced by ASP.

<div class="references_section">