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

  • Question

  • User1221255619 posted

    Hi,

    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?

    Regards,

    Garrett

     

    Thursday, April 17, 2008 1:37 PM

All replies

  • User1409710157 posted

    Hi,

     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

     http://www.codeproject.com/KB/aspnet/paginguc.aspx

    using stored procedures. Looks quite elegant at first glance.
     

     

    Hope this helps

        Quincunx

         


     

     


     

    Wednesday, April 23, 2008 7:43 AM