jqGrid不显示行数,只显示总行数

您所在的位置:网站首页 jqgrid获取总行数 jqGrid不显示行数,只显示总行数

jqGrid不显示行数,只显示总行数

2024-01-07 12:25| 来源: 网络整理| 查看: 265

百度翻译此文   有道翻译此文 问题描述

I'm having a problem that I can't sort it out.

Please take a look at this image first

enter image description here As you can see, I have been able to request the JSON data from server. The pager shows that there were 4 records. But the records didn't shows in the table.

This is my javascript code

jQuery("#pickFlex66").jqGrid({ url: root + '' + '/listpicker', datatype: "json", altRows: true, mtype: 'POST', colNames:['Code','Company Name'], colModel:[ {name:'company_code',index:'company_code', width:100}, {name:'company_name',index:'company_name', width:100} ], rowNum:10, width: 540, height: 310, rowList:[10,20,30], pager: '#pagerFlex66', sortname: 'company_code', shrinkToFit: false, viewrecords: true, sortorder: "desc", caption:"", onSelectRow: function(id){ } }); jQuery("#pickFlex66").jqGrid('navGrid','#pagerFlex66',{edit:false,add:false,del:false,search:false});

And here is my JSON data

{ "page": "1", "total": 0, "records": "4", "rows": [{"id":"5","cell":["55-123","123"]},{"id":"3","cell":["123","IBM"]},{"id":"2","cell":["00000","BDO"]},{"id":"1","cell":["000-00","IT GROUP Inc "]}] }

Is there a mistake in my javascript? Or maybe in my JSON data?

推荐答案

I agree with Briguy37 that the value "total": 0 is strange and of cause incorrect. Nevertheless jqGrid should do display all data.

I suppose that you have the problem in the part of your code which you not posted here. How you can see from the demo the code which you posted can do read and display the JSON data.

其他推荐答案

Here's a couple issues...haven't figured out why your results aren't getting populated yet, though:

Total in your returned JSON should be the number of pages. Because it is set to 0, that is why it is displaying 0. Also, you'll probably want to return rowCount as 10 in case you change the number of results per page.

其他推荐答案

You are missing a json reader, I had the exact same problem.

$("#list").jqGrid({ url : "my-json-table-action' />", datatype: 'json', jsonReader: { root: 'gridModel', id: 'idTT', repeatitems: false, }, resize: false, hidegrid: false, data: 'trabajosTerminales', mtype: 'POST', height: 'auto', colNames:['No. de Registro', 'Título', 'Tipo', 'Periodo'], colModel :[ {name:'numRegistro', index:'titulo', search: 'true', stype:'text', align:'center' searchrules:{required:true}, width:100 }, {name:'titulo', key:'true', index:'titulo', search: 'true', stype:'text', searchrules:{required:true}, width:800 }, {name:'tipo', key:'true', index:'tipo', search: 'true', stype:'text',align:'center', searchrules:{required:true}, width:100 }, {name:'periodo', key:'true', index:'titulo', search: 'true', stype:'text', searchrules:{required:true}, width:100 }, ], pager: '#pager', rowNum:10, rowList:[10,20,30], viewrecords: true, gridview: true, caption: 'Trabajos Terminales dirigidos', }); jQuery("#list").navGrid('#pager',{edit:false,add:false,del:false}); });

Where the root element is the array that contains your data, in this case I'm returning my data in an array called 'gridModel', the id is not necessary. But you have to make sure to set the root element right, in your case it's called 'rows' instead 'gridModel'.



【本文地址】


今日新闻


推荐新闻


CopyRight 2018-2019 办公设备维修网 版权所有 豫ICP备15022753号-3