How to fetch data for a large Gird from a database?
I have a grid with 10000 rows and 20 columns.
I want to make sure that the viewer will not experience a large delay when is browsing the grid. The size of display allows the user to see only 15 rows at a time.
I am thinking to open create an empty array which can hold all the data for the gird.
When the user displays the grid for first time, I will fetch the data for the first 15 rows and as he moves the scroll bar down I will go a fetch more data from server.
How do I get an event telling me the position of the scroll bar?
or what are the row numbers that are displayed after moving the scroll bar?
Thanks
MS
I want to make sure that the viewer will not experience a large delay when is browsing the grid. The size of display allows the user to see only 15 rows at a time.
I am thinking to open create an empty array which can hold all the data for the gird.
When the user displays the grid for first time, I will fetch the data for the first 15 rows and as he moves the scroll bar down I will go a fetch more data from server.
How do I get an event telling me the position of the scroll bar?
or what are the row numbers that are displayed after moving the scroll bar?
Thanks
MS
MHS
June 8,