dropdownlist proble

[indian22]

How to increase the speed of dropdownlist selected index change event while more than 10000 records in the database? I have five dropdownlist in a single page,values for that dropdownlist binded from the database when another dropdownlist selected index change event,it takes more time. Plz help me

[Abhijit Jana]

indian22 wrote:

How to increase the speed of dropdownlist selected index change event while more than 10000 records in the database?

What is the reason behind showing 10,000 records in Dropdown list? Use some filter criteria to minimize the number of records. You can also use data caching to read data from cache rather than hitting the database every selected index change.

cheers, Abhijit CodeProject MVP

[indian22]

I am begginer,I don't know about data caching,will you plz send me any link to populate me in right direction Thank you

[Abhijit Jana]

indian22 wrote:

I don't know about data caching,will you plz send me any link to populate me in right direction

Ya that I can do for you. But my question was why you are loading 10000 records in dropdownlist? Data Caching in ASP.Net

cheers, Abhijit CodeProject MVP

[indian22]

I have binded customer name in that dropdownlist from customer table,my customer table contain more than 5000 records