View Full Version : Grid Pagination Issue

18 Sep 2013, 8:25 PM
I have some issue with pagination, basically my database has 30,000+ rows so trying to load data using remote pagination features and my page size is 25. I can't return all rows from my database because response data going to be huge and nothing will display on grid so retrieving 25 rows per page and implimented row number logic in sql that working as expected but on GUI total page count shows 1 and display message shows 1-25 of 25.

I assume, my data the totalRecords may be wrong. can anyone suggest me?, appreciate if you post some example.
I am using asp.net webserivce for data.

In my store:
var store = new Ext.data.JsonStore({
autoLoad: true,
storeId: 'mystore',
model: 'Book',
proxy: new Ext.data.HttpProxy({
type: 'ajax',
method: 'POST',
url: "Service2.asmx/GetPeople",
headers: {'Content-type': 'application/json'},
writer: {type: 'json'},
reader: new Ext.data.JsonReader({ root: 'd', totalProperty: 'totalRecords', idProperty: 'SEQ_NO' })

In Grid Panel:
remotePage: true,
bbar: Ext.create('Ext.PagingToolbar', {
store: store,
displayInfo: true,
displayMsg: 'Number of records {0} - {1} of {2}',
emptyMsg: "No data available"


Response from webservice:
<?xml version="1.0" encoding="utf-8" ?>
- <ArrayOfModel_Summary xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://tempuri.org/">
- <Model_Summary>

webservice is serialized as:
[ScriptMethod(ResponseFormat = ResponseFormat.Json, UseHttpGet = true, XmlSerializeString = false)]

can anyone suggest me what I am doing wrong here?.