Custom Pagination using count of rows as parameter to Datatables
Custom Pagination using count of rows as parameter to Datatables
Hi everyone,
I am using datatable to display rows of data. For performance issues...instead of loading hundreds of rows , based upon the filters(10 rows, 15 rows) i fetch only only so much data to feed into the datatable using my custom paging stored procedure. In addition , the Sp retrieves the total count of rows, so that using this total count , we could somehow display appropriate pagination.
Let me illustrate:
suppose, based on a given set of conditions , the rows (total) retrieved are 100. But the datatable filter is set to display only 10 rows, the SP , will fetch only those 10 rows , and the count is computed separately as 100. When displaying data , the user sees only the 10 rows , however since there are 90 more as per condition, i need to show appropriate pagination.
Could someone please guide me as to how to accomplish this as i am very new to datatables and need to do this ASAP.
thanks,
Philip
Answers
ALso i am using asp.net using c# as the server side