i need to populate many no. of drop downs from the db.
the no. of values coming form db will be in thousands.
so it will decrease the speed of the page for loading.
wt will be solution for this prob???

reduce the amount of data being sent to the page. There is no reason to load up thousands of items into a drop down.

I agree with jBenson, there is no reason to load 1000's of records into a dropdownlist not only that, do you expect your users to wade through 1000's or records to find the one they are looking for? You are better off filtering the result set by breaking the records out into categories and allow your users to select which category of records they want to deal with.

"The one language all programmers understand is profanity."

i agree u but m not getting wt exactly shud i do?
can i make use of XML
will it do anything?
and if so...how to make use of that?

Technology or buzzwords will not solve this one for you.

What you need is design. dparsons suggestion is spot-on:

1. Find a way to categorize the records
2. Load only the categories into the drop-down
3. If the user clicks on a category, load another drop-down with its members, or repeat from step 1 if required.

Joel

If you dont understand the concept behind this go to this website:

http://store.summitracing.com/eadvse...earchType=Make

That site makes use of what you should do, it dynamically changes all dropdown boxes based upon your initial selection. As you make a selection from the dropdown, the (main) drop down disappears and is replaced with plain text, this prevents your users from making a bunch of selections, then going back and altering the main category.

(To allow for functionality that would allow a user to change categories on the fly like that isnt overly difficult but will be come a pain in the amount of records you are talking about.)

As joel said, buzzwords arent going to get you out of this; sure you COULD use XML, but the XML file would simply replace your database as your datasource. Simply put, the only way to remedy your problem is going to be to apply some sort of filtering on your resultsets.



"The one language all programmers understand is profanity."