469,926 Members | 2,248 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,926 developers. It's quick & easy.

How to view my database table in my dropdownbox

hi guys need help again!!!! i want to retrieve data from the database table and put inside my drop down box.For example i want to view all my products example
F216,F217,F218 in my dropdown box.how to do that?How to view all data in column in my dropdownbox.
Oct 16 '07 #1
1 1060
3,406 Expert 2GB
The basic idea:
Expand|Select|Wrap|Line Numbers
  1. rs.open "SELECT productID FROM dbTable", conn
  2. response.write "<select>"
  3. do until rs.eof
  4.    response.write "<option>" & rs("productID") & "</option>" & vbNewLine
  5.    rs.movenext
  6. loop
  7. response.write "</select>" & vbNewLine
Oct 17 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

6 posts views Thread by thomas j | last post: by
2 posts views Thread by Lars Netzel | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.