Forum

November 2nd, 2014
A A A
Avatar

Lost password?
Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

The forums are currently locked and only available for read only access
sp_Feed Topic RSS sp_TopicIcon
Gird Pager with a lot record
08/08/2013
17:20
Avatar
iccsi
Member
Members
Forum Posts: 18
Member Since:
28/07/2013
sp_UserOfflineSmall Offline

I have following code to create my jqGrid which works for 30 to 70 records.

The pager failed to scroll when my data set return more than 300 records.

Because the start date and end date, it returns more 300 records sometimes. The pagers shows page 1 of 33 and view of 1 - 10 of 325 which is fine when jqGrid created.

I tried to click next page than the pager shows page 2 of 1 and no records to view.

I am able to scroll the pages when the data set return around 70 records.

Do I misss any information to pass the url function like ROWS, PAGE, TOTAL and TOTAL RECORDS?

I have jsonReader to get information, but should I send those information at run time while user click on next page.

Thanks in advance for the information and help,

Regards,

Iccsi,

 $("#MyGrid").jqGrid({
        url: 'MyUrl.cfc?method=MyMethod&StartDate=01/01/2008&EndDate=05/05/2011',
        datatype: 'json',
 mtype: 'GET',
        colNames: [ 'MyID','MyName','MyDate','MyNote'],
        colModel: [
      { name: 'MyID', width: 40  },
       { name: 'MyName', width: 40 },
            { name: 'MyDate', width: 50 },
            { name: 'MyNote', width: 50 }
           
                   
        ],
        pager: $('#GirdPager'),
        rowNum: 10,
        rowList: [10, 20, 30],
        sortname: 'MyID',
        sortorder: 'desc',
        viewrecords: true,
        gridview: true,
        autoencode: true,
  pginput: true,
        caption: 'My Gird',
       
  jsonReader: {root: "ROWS",
               page: "PAGE",
                    total: "TOTAL",
                    records: "RECORDS",
                    cell: "",
                    id: "0"
                    },
  
      
    }

    });

Forum Timezone: Europe/Sofia

Most Users Ever Online: 496

Currently Online:
58 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

OlegK: 1255

markw65: 179

kobruleht: 144

phicarre: 132

YamilBracho: 124

Renso: 118

Member Stats:

Guest Posters: 447

Members: 11373

Moderators: 2

Admins: 1

Forum Stats:

Groups: 1

Forums: 8

Topics: 10592

Posts: 31289

Newest Members:

, razia, Prankie, psky, praveen neelam, greg.valainis@pa-tech.com

Moderators: tony: 7721, Rumen[Trirand]: 81

Administrators: admin: 66

Comments are closed.
Privacy Policy   Terms and Conditions   Contact Information