jQuery Grid Plugin – jqGrid

Hi – How can I get more than 100 rows to show up in my jqGrid? I'm using JSON data and the file has more than 100 rows but nothing shows up. On the other hand if I limit it to 100 rows all the rows show in grid.

Thanks

Abel

tony said:

Hello,

Check your rowNum parameter in jqGrid. Also check if your server return the correct data.

Regards

Tony

Hi

Great control!

Actually, i do have it set to 1000 and the server is sending 1000 rows of data. I included some details. Let me know if you need more!

jQuery("#list2″).jqGrid({
    url:'/iBatisPlay/experimental/data.json?nd='+new Date().getTime(),

    datatype: 'json',

        jsonReader : {
          root: "rows",
          page: "page",
          total: "total",
          records: "records",
          repeatitems: true,
          cell: "cell",
          id: "id",
          userdata: "userdata",
          subgrid: {root:"rows",
            repeatitems: true,
            cell:"cell"
          }
        },  
       
    colNames:['#','Contact Name','Last Name','First Name','Company','Phone','Address','Email'],  

    colModel:[
        {name:'ID',index:'ID',width:50,sorttype:"float"},
        {name:'ContactName',index:'ContactName',width:125, editable: true},
     {name:'lastname',index:'lastname', width:75},
        {name:'firstname',index:'firstname', width:75},
        {name:'company',index:'company', width:125},
        {name:'phone',index:'phone', width:125},
        {name:'address',index:'address', width:250},
        {name:'email',index:'email', width:125}
    ],
   
    pager: jQuery('#pager2'),

    rowNum:1000,
   
    imgpath: '/ibatisplay/experimental/images',

    sortname: 'id',

    viewrecords: true,
   
    sortorder: 'desc',
   
    caption: 'Contacts DEMO',
   
    loadonce: true,
   
    loadtext: "Loading contacts…",
   
    multiselect: true,   
   
    multiboxonly: true,
   
    toolbar: [true,"top"],
   
    height: "50%"
});
});

Snippet of Data

{total: 11,

page: 1,

records: 1000,

rows: [

{id: '14835', cell:['1','','','','Knoll Showroom','416-365-3000 (Office Direct)','109 Atlantic Avenue Suit 200 -- Toronto -- ON -- -- M6K 1X4','']}

,{id: '14762', cell:['2','(Akan) Bowyer, Sheila','(Akan) Bowyer','Sheila','RBC Dexia Investor Services Trust','416-955-3514 (Office Direct)','200 Bay Street, 24th Floor -- Toronto -- ON -- Canada -- M5J 2J5','sheila.bowyer@rbcdexia-is.com']}

,{id: '14859', cell:['3','007, Contact','007','Contact','','','','']}

,{id: '792', cell:['998','Bezalel, Aharon','Bezalel','Aharon','','0119-722-641-1455 (Office General)','Mevo Hashar 3 Ein-Kerem -- Jerusalem 95-744 -- Israel','rachelfr@zahav.net.il']}

,{id: '1917', cell:['999','Bhardwaj, Rahul','Bhardwaj','Rahul','The AGO Foundation','905-474-9974 (Office General)','United Way York Region 80F Centurian Drive Suite 200 -- Markham -- ON -- Canada -- L3R 8C1','rbhardwaj@uwyr.on.ca']}

,{id: '793', cell:['1000','Bhargava, Paras','Bhargava','Paras','BMO Nesbitt Burns','416-359-6941 (Office Direct)','1 First Canadian Place 100 King Street West P. O. Box 150 -- Toronto -- ON -- Canada -- M5X 1H3','']}

]}

Thank you

Abel

My problem was that the data was NOT formatted correctly. I added one row at a time (15, 16, 17 etc…) to discover the individual column data was the problem.