Dynamic, database backed dropdown lists

Tutorials Shared by the Internet Community


  Top Tutorials     New Tutorials     Submit     Login     Register  

Dynamic, database backed dropdown lists

How to build a dynamic dropdown list with ASP and database data.
  • Total Hits: 21550

  • Average Rating :
    URL RatingURL RatingURL RatingURL RatingURL Rating


  • Total Votes: 150 votes

  • Category: ASP/Database Concepts

  • Submitted on: 2008-03-06 09:38:59

  • Submitted By: Devesh Khanna

  • Set as Favorite


Dropdown lists in HTML are very useful for multiple-option choices, especially within a web form that user needs to fill out.

Producing them dynamically from a database can saves a lot of time and energy.

In this example, we will use ASP 3.0 to generate dynamic dropdown lists from a Microsoft Access database. The database table in question contains fruit and vegetable types.    More detail...

Rating Detail

 Stars  Percentage  Total Vote
 One star  Vote LeftVote MiddleVote Right 37.33%  56
 Two starsTwo star  Vote LeftVote MiddleVote Right 10.67%  16
 Three starsThree starsThree stars  Vote LeftVote MiddleVote Right 12%  18
 Four starsFour starsFour starsFour stars  Vote LeftVote MiddleVote Right 12%  18
 Five starsFive starsFive starsFive starsFive stars  Vote LeftVote MiddleVote Right 28%  42

Caste Your Vote

 Rating  Selection  Guidelines
 Poor:     Very disappointing, useless.
 Fair:     Below average, disappointing but not useless.
 Good:     About average in its class.
 Very Good:     Above average for its category.
 Excellent:     One of the best Tutorials in its category.