jQuery Grid Plugin - jqGrid

Hi Tony,

First of all congratulations on this fantastic grid.

I am having similar problem. can you tell me if i am doing something wrong i am using java spring/jsp? Also i want to get rid of all the pagenation stuff from this grid and dumpo all the records on to the page, i can do that but not able to get rid of the page 1 of 1 and the buttons associated.

-====-

jQuery(document).ready(function(){

    var mystr = <%=request.getAttribute("myjsonstr")%>;

    jQuery("#mygrd").jqGrid({
        url:'loadProductSummary.do',    
        datatype: "jsonstring",
        datastr: mystr,
        colNames:['Rate ID','Region', 'Comment', 'Update By', 'Update Time'],
        colModel:[ {name:'Rate ID',index:'Rate ID', width:80, sorttype:'int', editable:true, editoptions:{size:10}},
            {name:'Region',index:'Region', width:80, editable:true, edittype:"select", editoptions:{value:nameSelect(),size:10}},
            {name:'comment',index:'comment', width:250, editable:true, editoptions:{size:10}},
            {name:'update_by',index:'update_by', width:100, sorttype:'float', editable:true, editoptions:{size:10}},
            {name:'update_time',index:'update_time', width:100, sorttype:'date', editable:false, editoptions:{size:10}}
        ],
        rowNum: 1000,
        pager: '#pagernav',
        sortname: 'Rate ID',
        viewrecords: true,
        sortorder: "asc",
        shrinkToFit: false,
        width: 1024,
        height: 450,
        caption:"Rates View",
        editurl: "jsonServlet?action=edit",
        onSortCol: function()    {
            alert('In the onSortCol');
            jQuery("#ratematrix").setGridParam({datatype:'local'});
        },
        loadComplete: function () {
            alert('In the loadComplete');
            jQuery("#ratematrix").setGridParam({datatype:'json'});
        },
        gridComplete: function () {
            alert('In the gridComplete');
            jQuery("#ratematrix").setGridParam({datatype:'json'});
        },
        jsonReader : { root: "rows", page: "page", total: "total", records: "records", repeatitems: false, cell: "rows", id: "id"} 
      });

    jQuery("#mygrd").jqGrid('navGrid','#pagernav',
        {view:false, refresh:true, search:false}, //options
        {checkOnSubmit : true, reloadAfterSubmit:false, closeOnEscape:true, bottominfo:"Fields marked with (*) are required",
            afterShowForm: function(eparams) {
                document.getElementById('Rate ID').disabled = true;
            }
        }, // edit options
        {checkOnUpdate:true,checkOnSubmit : true, reloadAfterSubmit:true, closeOnEscape:true,bottominfo:"Fields marked with (*) are required",
            afterShowForm: function(eparams) {
                document.getElementById('Rate ID').disabled = true;
            }
        }, // add options
        {reloadAfterSubmit:false,closeOnEscape:true}, // del options
        {closeOnEscape:true}, // search options
        {navkeys: [true,38,40], height:250,jqModal:false,closeOnEscape:true} // view options

    );

});

</script>

    <table id="mygrd" class="scroll"></table>
    <div id="pagernav" class="scroll" style="text-align: center;"></div>

Best

- Shah

Thanks Tony,

my initial setting is datatype: "jsonstring"

I want local sort, however when i press refresh it should be json. the refresh works fine as long as i do not sort the grid. once i sort, the datatype is set to local and the sort works locally taht is what i want. but once the sort is done the locaComplete or gridcomplete does not fire. how do i change the datatype back to json for refresh?

        onSortCol: function()    {
//            alert('In Sort');
            jQuery("#ratematrix").setGridParam({datatype:'local'});
        },
        loadComplete: function () {
//            alert('load Complete');
            jQuery("#ratematrix").setGridParam({datatype:'json'});
        },
        gridComplete: function () {
//            alert('gridComplete');
            jQuery("#ratematrix").setGridParam({datatype:'json'});
        },