ansaurus

Question

jqgrid howto send all rowData in json format to server?

Answer 1

+1 A:

You approatch from your other question is OK, but jQuery.ajax has problems to serialize arrays. The most reliable and standard way (see here and here as examples) which I see is to serialize all jqGrid data to JSON (for example with respect of JSON.stringify function:

$("#sendButton").click(function(){
    var gridData = jQuery("#list").getRowData();
    var postData = JSON.stringify(gridData);
    alert("JSON serialized jqGrid data:\n" + postData);
    $.ajax({
        type: "POST",
        url: "/cpsb/internalOrderList.do",
        data : {
            jgGridData: postData,
            customData: "bla bla"
        },
        dataType:"json",
        contentType: "application/json; charset=utf-8",
        success: function(response, textStatus, xhr) {
            alert("success");
        },
        error: function(xhr, textStatus, errorThrown) {
            alert("error");
        }
    });
});

the names of parameters jgGridData, customData and so on you can choose how you as like.

Oleg 2010-09-28 21:27:34

@Oleg thanks! so in customData i can append the earliest and latest time ? ....

paul 2010-09-28 22:50:47

@Oleg I have a quick question.why my JSON is appending null at beggining..update1

paul 2010-09-29 19:22:04

@paul: In my experiments I had not such effect. Probably the entry come from the header where exist checkbox used for multiselect (select/deselect all rows). You can test whether the entry exist and if exist remove it: `if (!gridData[0].licensePlateNumber) { gridData.splice(0, 0); }`. The question about `customData` I suppose you solved yourself: you can send any data like `earliest` or `latesttime` which you need. You can either add a new properties to the `gridData` with `gridData.earliest = "my earliest";` or use `data: {jgGridData: postData, earliest: "my earliest", latesttime: 123}`

Oleg 2010-09-29 21:15:14

@Oleg thanks! i tried with $("#orderPreview ").find("tr:eq(0)").remove(); and its working now....its a hack but working...

paul 2010-09-29 22:58:17

@paul: So will be run also. You should be careful with the manual modification in jqGrid because of possible side effects. You can try to post existence of the row 0 as a bug on http://www.trirand.com/blog/?page_id=393/bugs/. Either Tony confirm that is a bug or he explain why the row is needed. In the last case you should better modify only the data which you need to post and not the jqGrid itself.

Oleg 2010-09-29 23:03:50

@tOleg..Thanks! I am checking in my server side code for that as well ...so that don't have to hack it in my side...I have posted a question on which I am adding rows from my first grid to second grid like shopping cart(which you have answered before) ...and I am sending second grid data to server which will convert into persistent data and save in database...so the bug is from adding the data from grid 1 to 2 ...

paul 2010-09-30 00:50:05

ansaurus

tags:

views:

answers:

jqgrid howto send all rowData in json format to server?

related questions