Last post Apr 23, 2008 07:43 AM by quincunx
Apr 17, 2008 01:37 PM|GarrettBrennan|LINK
I have a gridview displaying info from SQL database.
When I view it on my PC, the "next" and "previous" paging links work correctly.
However, on my cell phone these links don't load in a new page of data.
Can anyone help me on this please?
Apr 23, 2008 07:43 AM|quincunx|LINK
Ive had a similar problem creating webpages designed for Windows CE platforms.
My problem stemmed, (i think ) from passing too many rows into the gridview control as the asp paging control loads the whole query result into memory.
This is not a problem in most cases except when i tried to load over 21k rows and blew some kind of limit of the devices memory.
One quick fix in some scenarios would be to up the amount of memory IE is allowed to use (this didn't work for me!).
My quick solution was to change my SQL to select the TOP 500 or something from the table (not the best idea but i figured no one would have the patience to got through all 100 pages (5 items per page).
However , a more elegant solution would be to make your own form of paging control which loads the
next TOP 500 each time you page.
Heres another idea too
using stored procedures. Looks quite elegant at first glance.
Hope this helps