Load from database to a combo box

[reeta82]

how to load the informations from database to a combo box using asp...eg:type of courses available...plz help

[ZoSoo7]

Give this a try, also if you wanted to, you can place another
value from your recordset within the option tags value attribute in case you have a unique key for your display value

<%
dim oConn, oRs
set oRs = CreateObject("ADODB.Recordset")
set oConn = CreateObject("ADODB.Connection")

'set your connection string
oConn.open "sdfsdlfkhweohiefwhoifew"

set oRs = oConn.execute("Select fieldName from myTable")

response.write "<select name=''cboComboBox'>"

do while not oRs.eof
resposne.write "<option>" & oRs("fieldName") & "</option>"
oRs.movenext
loop
%>

[reeta82]

thanks a lot......