By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,666 Members | 1,909 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,666 IT Pros & Developers. It's quick & easy.

How to view my database table in my dropdownbox

P: 6
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
Share this Question
Share on Google+
1 Reply


jhardman
Expert 2.5K+
P: 3,405
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.