jQuery Grid Plugin - jqGrid - Topic: jqGrid loadonce problem

JeffV on jqGrid loadonce problem

Fri, 02 Jul 2010 23:38:50 +0300

I'm not sure anyone is watching this thread anymore,

But when I made these changes when I click on the "Next" button I get an error stating:

J.toUpperCase is not a function

jquery.jqGrid.min.js

Line 19

complete :function (…){

…..

$("#mygrid").setGridParam({datatype:'local'});

}

limasdf on jqGrid loadonce problem

Thu, 04 Mar 2010 10:00:48 +0200

mdmangus 's solution 100% work perfectly thank you!

mdmangus on jqGrid loadonce problem

Sat, 13 Feb 2010 02:02:41 +0200

I had the same need as the original poster. Tony's reply shows the datatype needed to be set to local for the grid to sort client side.

I did the following that way I could have local sorting, but have ajax requests to be fired in other scenarios.

        //
        // loadGrid anonymous function
        var loadGrid = function(postdata) {
            … code ajax request, whatever..
        }

        $("#mygrid").jqGrid({
            datatype: loadGrid,
            rowNum: -1, // show all rows
            loadonce: true, // disabled paging and all sorting done locally
            … other jqGrid options,
            onSortCol: function(index, iCol, sortorder) {
                //
                // Grid loaded all records, so sort locally
                // Re-Wire datatype for ajax in Grid Complete
                $("#mygrid").setGridParam({ datatype: 'local' });
            },
            gridComplete: function() {
                //
                // Rewire datatype to ajax function
                if ($("#mygrid").getGridParam("datatype") === "local")
                    $("#mygrid").setGridParam({ datatype: loadGrid });
            }

With that in place your grid will switch to datatype: local when you click the sorting column and after completion it sets the grid back to the function that cotains your code and web service call.

Hope this helps others.

tony on jqGrid loadonce problem

Sun, 30 Aug 2009 09:59:32 +0300

Hello,

loadonce work only with the predefined loaders. If you use datatype as function you should set datatype:local manually after the first loading of the grid with the custom function. Something like:

datatype : function (){

$.ajax({

...

complete :function (...){

.....

$("#mygrid").setGridParam({datatype:'local'});

}

})

Best Regards

Tony

marko999 on jqGrid loadonce problem

Wed, 26 Aug 2009 06:03:56 +0300

hi all, I am using jqGrid with asmx web services…because services need to be called on specific way, I am using datatype parameter as a function call in which I am calling web service using jquery $.ajax method

Here is my code:

datatype: function() {
$.ajax({
url: 'Default.aspx/GetPersons',
data: “{}”,
type: “POST”,
dataFilter: function(data) {
var msg = eval('(' + data + ')');
if (msg.hasOwnProperty('d'))
return msg.d;
else
return msg;
}

everything works fine, I am getting json from the server and grid display
everything as suppose to. But, from some strange reason,
I can't accomplish sorting on client via loadonce: true attribute, for
every event on grid, grid calls server...

Any ideas how to solve this?

cheers

Marko