jQuery Grid Plugin - jqGrid - Topic: JSON Post Format?

partoo on JSON Post Format?

Fri, 26 Feb 2010 19:11:38 +0200

Hi Sloan!

Can you give me your solution?

Sloan Thrasher on JSON Post Format?

Fri, 14 Aug 2009 11:07:12 +0300

Hi Matthew!

Never mind -- I think I found it! You example was very helpful and got me going in the right direction.

Sloan

Sloan Thrasher on JSON Post Format?

Fri, 14 Aug 2009 10:49:46 +0300

Matthew said:

Mmm my post tells you one of the available formats…

btw who is Jason O_o

Sorry 'bout that Matthew!, must have been cranial flatulance on my part.

I must be confused. In reading your post above, it appeared to be just the format to send to the server. I'm an ASP (classic) programmer, so the PHP examples haven't helped. I guess I'm wondering how the submit to the ASP program will look. For instance, what is the name of the submitted info in the request object? How do the rows appear when saving data from the grid?

My guess from your example is that I'll get a form value for each of the parameters (i.e. page, pagesize, sortiindex, and sortdirection) If I specify each column in a row, will I receive a form value for "row", and then the fields in the row?

Thanks for your patience!

Sloan

Matthew on JSON Post Format?

Thu, 13 Aug 2009 14:50:26 +0300

Mmm my post tells you one of the available formats...

btw who is Jason O_o

Sloan Thrasher on JSON Post Format?

Thu, 13 Aug 2009 12:08:42 +0300

Matthew said:

If you're going to be posting JSON you're probably better of using a custom data function like this..

setup your grid with the datatype option set as

datatype : function(pdata) { getData(pdata); }

and here is the function…. note the params object which is what i send JSONified to my webservice… which can be anything you want… and in my case the data that gets sent is…

{”page”:1,”pageSize”:25,”sortIndex”:”id”,”sortDirection”:”desc”}

see how they match my “params” object …

    function getData(pdata) {
        var params = new Object();
        params.page = pdata.page;
        params.pageSize = pdata.rows;
        params.sortIndex = pdata.sidx;
        params.sortDirection = pdata.sord;

        $.ajax({
            type: “POST”,
            contentType: “application/json; charset=utf-8″,
            url: “YourWebservice.asmx/GetGridData”,
            data: JSON.stringify(params),
            dataType: “json”,
            success: function(data, textStatus) {
                if (textStatus == “success”) {
                    var thegrid = $(”#YourGrid”)[0];
                    thegrid.addJSONData(data.d);
                }
            },
            error: function(data, textStatus) {
                alert('An error has occured retrieving data!');
            }
        });
    }

Hi Jason,

I've got the format for sending the data to the grid. I'm wanting to know what format the data is sent to the server.

TIA!

Sloan

Matthew on JSON Post Format?

Thu, 13 Aug 2009 10:53:03 +0300

If you're going to be posting JSON you're probably better of using a custom data function like this..

setup your grid with the datatype option set as

datatype : function(pdata) { getData(pdata); }

and here is the function.... note the params object which is what i send JSONified to my webservice... which can be anything you want... and in my case the data that gets sent is...

{"page":1,"pageSize":25,"sortIndex":"id","sortDirection":"desc"}

see how they match my "params" object ...

    function getData(pdata) {
        var params = new Object();
        params.page = pdata.page;
        params.pageSize = pdata.rows;
        params.sortIndex = pdata.sidx;
        params.sortDirection = pdata.sord;

        $.ajax({
            type: "POST",
            contentType: "application/json; charset=utf-8",
            url: "YourWebservice.asmx/GetGridData",
            data: JSON.stringify(params),
            dataType: "json",
            success: function(data, textStatus) {
                if (textStatus == "success") {
                    var thegrid = $("#YourGrid")[0];
                    thegrid.addJSONData(data.d);
                }
            },
            error: function(data, textStatus) {
                alert('An error has occured retrieving data!');
            }
        });
    }

Sloan Thrasher on JSON Post Format?

Thu, 13 Aug 2009 10:40:45 +0300

Hi all,

How do I find out the format of the requests sent to the server?

I've searched the forums, and the documentation, but haven't been able to find the info.

Any help would be greatly appreciated!

TIA

Sloan