I have a dropdownlist binded to a sqldatasource and the result set contains about 394,000 serial no. This is making the page crash and i cannot mess with the table architecture. I would like to know if trhere is a way to limit the results and then retrieving more after the user has scrolled down more. I believe it could be done with sql cursor fetch and previous but i dont know how to implement it to the dropdownlist. If someone could be of help i would appreciate it.