Gridview paging: "next" and "previous" links not working RRS feed

  • Question

  • User1221255619 posted


    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?




    Thursday, April 17, 2008 1:37 PM

All replies

  • User1409710157 posted


     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






    Wednesday, April 23, 2008 7:43 AM