locked
how to do paging in classic asp with dropdown RRS feed

  • Question

  • User1067945151 posted

    hi all 

    my requirement is i have to do pagination using dropdown on select if i select 20 20 records should show and if i select 30 30 records should show  i want by classic asp 

    Tuesday, November 7, 2017 9:49 AM

All replies

  • User-420868782 posted

    Hi ravivani,

    To implement paging, you can try these strategies:

    1. You can try to use AJAX to make request to server and get the data, and then you can use some jQuery datatable plugin with pagination and populate datatable plugin with your data.
    2. You can also do paging on server side. You can pass dropdown selected value as “PageSize”, and then you can pass “PageSize” and “CurrentPageIndex” to server side method and do a query from your database to retrieve paged records.     

    With Regards,

    Fei Han

    Wednesday, November 8, 2017 5:34 AM
  • User-622904280 posted

    Hi Ravivani

    Following on from suggestion 1, I've used the Datatable jquery plug in (https://datatables.net/) on Classic ASP projects, it's a simple and quick way of doing what you need without having to write too much code yourself.

    Thursday, November 9, 2017 9:54 AM