custom paging displaying records on request

svibuk

i have custom paging for a grid with first next prev last

my issue is with current code it takes a lot of time for post back & going to next page & displaying records

even page loading takes time

so i needed to load the records on request

means suppose the pagesize is 50 records per page

on inital page load only 50 records will be displayed from database instead of all say 2000 records

& then when user clicks next next 50 will be loaded from database to grid & so on

how can this be queried & coded

Mudassar

0 1

Refer here

svibuk

0 2

i tried the same its working fine

but not able to modify with the existing code which i have

1) i dont have stored procedure

2) the query for bindingthe grid is alred in my aspx.cs page

without using SP 7 WITH TEH EXIsTING CODE need to do it

Mudassar

0 3

Custom Pagination cannot be done using queries. You will have to use stored procedure there's no alternative for that as the query is very long

svibuk

0 4

ok will try & get back

& instead of page numbering how do i use first prev next & last

and secondaly i am calling the grid bind function in multiple places as i have filters aslo

Mudassar

0 5

You can pass multiple parameters to stored procedure and add where clause to the qury to filter