How to transfer data to a "Select Menu" ?

[Guest]

I have a Select Menu (pull down list) in my form. I have extracted the
customer list from a database and want to load the list to this Select Menu
so that users can pick their choices from the list. Appreciate if anyone can
show me an example or direct me to other resources. Many thanks.

 

[Stefan B Rusynko]

See http://asp101.com/samples/db_pulldown.asp

--




| I have a Select Menu (pull down list) in my form. I have extracted the
| customer list from a database and want to load the list to this Select Menu
| so that users can pick their choices from the list. Appreciate if anyone can
| show me an example or direct me to other resources. Many thanks.

 

[Guest]

Thanks but I would like to know, with your expertise experience, what is the
performance if the extracted data contains thousands of records? The .aspx
is a server-side program so the list is supposed be ready in the server
before the page is sent to browser. For a page with thousands of records
included, I wonder how long it takes for the page to download?

 

[Thomas A. Rowe]

Basically, you would have to run this to see, but also keep in mind, will users really want to
scroll thru that many records to make a single selection. You might want to see if it is possible to
break this function into two or more parts, maybe first select a category, then display only those
records within that category, etc.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

 

[Guest]

Thanks for your advise. It seems web application design is quite different
from traditional design. If we select category first, there will be many
pages have to load.

 

[Thomas A. Rowe]

A few extra pages shouldn't really make a difference to a user, but it will reduce the impact on the
server/database/application, if you have 1,000s of records to fill the drop downs.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

 

[Guest]

Yes, I got you. Thanks

A few extra pages shouldn't really make a difference to a user, but it will reduce the impact on the
server/database/application, if you have 1,000s of records to fill the drop downs.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================