Populating a dropdown list from a database

Home > Asp > Tutorials > Populating a dropdown list from a database - ASP Tutorial

Tell a friend

Link to us

Total Members

Members: 84705

Home

1 . Introduction to ASP

2 . Setting up your ASP environment

3 . First ASP Page

4 . Active Server Objects

5 . Global.asa

6 . Application Object

7 . Session Object

8 . Request Object

9 . Response Object

10 . Server Object

11 . ASP Server Side Includes

12 . Connecting to a database

13 . Returning a recordset from a database

14 . Formatting a recordset as a HTML table

15 . Populating a dropdown list from a database

16 . Creating an automated email

17 . Sending attachments via an automated email

18 . What is the FileSystemObject?

19 . Total number of users are accessing the ASP application?

20 . Logging users

ASP Home

ASP Members (23087)

ASP Member Articles ( 29 )

- ASP Unanswered Questions

ASP Resources

ASP Source Code (238)

ASP Blogs (0)

GROUPS

.NET

Java

Other

TUTORIALS

.NET

.NET Tutorial

ASP Tutorial

ASP.NET Database Tutorial

ASP.Net Security,Internationalisation And Deployment

Web Development

Software Development

Java

Java Web Component Tutorial

JSP And J2EE Design Tutorial

RESOURCES

Books (372 )

SUBMISSIONS

COMMUNITY

SITE

Asp Tutorial

Populating a dropdown list from a database

<< Prev: Formatting a recordset as a HTML table

Next: Creating an automated email >>

To populate a dropdown list from a database table,first open a recordset and read from it one record at a time and dynamically write a html dropdown list.

<%@ Language=VBScript %>



<% 'Create the recordset

set conn=server.createobject("adodb.connection")

set rs = Server.CreateObject("ADODB.Recordset")

conn.open session("connection_string")

set rs = conn.execute("select * from tblEmployee")

%>

<html>

<head>

<title>

</title>

</head>

<body>

<select name="Employee" size="1">

<%

do while not rs.eof %>

<%

response.write "<option value=" + Cstr(rs("EmpID")) +">" + rs("EmployeeName")+ "</option>"

rs.movenext

loop

%>

</select>

<% rs.close

set rs=nothing

conn.Close

set conn = nothing %>

</body>

</html>