c# - Get the page number and page size -

i need page size , page number of jsgrid. based on page number, need records db. because when use above 100k records, jsgrid got stuck , loading long period.

how page number of jsgrid? , want search text , pass cs method. don't want filter inside jsgrid using

loaddata: function (filter) {     return $.grep(clients, function (client) {         return (!filter["fieldname"] || client["fieldname"].tolowercase().indexof(filter["fieldname"].tolowercase()) > -1) )} 

it filtering data loaded in jsgrid. want pass search text cs.

to data bind in jsgrid,(serializing data)

  datatable dtitem = // data db foreach      (datarow row in dtitem .rows)      {      gridlist += "{'id':" + row["id"] + ",'name': '" + row["name"] + "'}, ";     } 

to search,need data filter area , pass along pagenumber sql procedure.

you decide on page size want in jsgrid options, example:

$("#table").jsgrid({   ...   paging: true,   pagesize: 10, //eg 10 rows per page   pageloading: true,   ... 

with above options, grid show paging controls, ie links allow user navigate next/previous page or jump page.

when pageloading true, filter parameter in loaddata method have 2 members, example:

filter: { pagesize: 10, pageindex: 2 } 

filter.pageindex determined navigation link user clicks. should use these 2 parameters shape database query accordingly return pagesize rows pageindex^th page (counting 0).

your loaddata method must not return whole data table! if using microsoft sql server, can return rows page like:

select * t1 offset pagesize*pageindex rows fetch next pagesize rows