ASP Scripts - JavaScripts - Code Snippets

1. Database value to List Boxy
Open a database, Connect it, retrieve the values with sql and populate the Listbox with them.
<%
set objConn=server.createobject("adodb.connection")
objConn.open "DSN=dbDSN;uid=username;pwd=password"
set rsValues=objConn.execute("select field from table where )
%>
<Form>
<Select>
<%
do while not rsValues.eof %>
<option> <%=rsValues(0)%> </option>
<%
rsValues.movenext
loop
rsValues.close
set rsValues = nothing
objConn.close
set objConn=nothing
%>
</Select>
</form>


Explanation:
The code connectes the database, takes the values from the table and stores it in a recordset (rsValues). The values are added in to the option form filed one by one using the do...loop and the list has been populated. To use this code Modify the database connection details, and sql.
Back to code snippet home...
Copyright © 2001 - 2012 Macronimous.com. Best Viewed in 1024 x 768 Resolution
Protected by Copyscape Web Plagiarism CheckerValid XHTML 1.0 Transitional Valid CSS!