dowload speed with datagrid

[Anne]

I have a editable datagrid with textbox or dropdownlist in each cell. When I
open this page, it is really slow. I have around 1000 rows with 20 columns
for the dataset. Is there a better way to fasten the download speed? I guess
the problem with the speed is those textboxes or dropdownlists in the form.
But I need a way to edit all the cells. I don't know if there is anyone who
has same experience as me. But how to solve this problem? Your input is
really appreciated.

Thanks,
Anne

 

[Michael Pearson]

You could do a few things:
1. Only allow edit on one row at a time
2. Page the datagrid so that you see fewer records at a time to edit
3. Use caching to cache the drop down lists.

I think #1 is the best solution. I can't imagine when a user would want to
edit almost every row at once for 1000 rows. I would think they would only
edit one at a time.

Michael