jQuery Grid Plugin - jqGrid

Hi Sloan!

It seems to me, if you'll use "hidden: true, editable: true, editrules: { edithidden: false}" instead of "editable: false,hidden:true", your problem will be solved.

Regards

Oleg

Hello Sloan,

I see different ways which can help you. First of all, if new row added send to server, server must returns back at least id. So, you can use one constructed parameter (tdr_ID + '_' + tdr_td_DB). Id will be always sending to server and back and id must be not a part of colModel at all. If tdr_td_DB is nullable, you can use strings like (tdr_ID + '_NULL') in such cases. They will be unique and can be an id. And such constructed Ids can be easy decoded to your real two Ids by server.

Second, if server generates or updates more data fields after data modification, you can use afterSubmit function, which be called by navGrid after Add or Edit action. If one version of such function enough for you in your whole program, you can set with so way:

$.extend($.jgrid.edit, {..., afterSubmit: function(response, postdata) {
            var res = $.secureEvalJSON(response.responseText);
            if (typeof res === "string") {
                postdata.RowVersion = res;
                return [true, ""];
            }
            else {
                postdata.RowVersion = res.RowVersion;
                return [true, "", res.Id];
            }
        }, ...});

or you can set it directly as a parameter of navGrid function:

jQuery(”#ColumnList”).jqGrid({
        url:'ColGrid_XML.asp',
        editurl: 'ColEdit_XML.asp',
        datatype: 'xml',
        mtype: 'POST',

        .....

caption: 'Columns'

    }).navGrid('#ColPager',
                  {add:true,edit:true,del:true,width:'400px'},  // navGridOptions
                  {},   // Edit options
                  {afterSubmit = function(response, postdata) {
                        var res = $.secureEvalJSON(response.responseText);
                        postdata.RowVersion = res.RowVersion;
                        return [true, "", res.Id];
                  }});  // Add options

In the example serever send back to the client JSON encoded data Id and RowVersion (timestamp of data row, which I use for concurency check).  Global version of afterSubmit detects Add or Edit situation based on respond data type. My server send back a string with RowVersion value back for the Edit action and an Object {Id,RowVersion} as a response to Add action. You can solve your problem with a close way.

Regards
Oleg

Hi Sloan,

it's a little another problem, but it could be also easy solved. You can add in you edit/add options as a parameter of navGrid a function onclickSubmit in your Detail grid. For example,

var grid = jQuery('#master').jqGrid({

...

var urlEditDetail='ColEdit_XML.asp';

var gridDetails = jQuery('#detail').jqGrid({

...

}).navGrid('#ColPager',
                  // navGridOptions:
                  {add:true,edit:true,del:true},
                  // Edit options:
                  {onclickSubmit: function(rp_ge, postdata) {
                       var sel_testcluster_id = grid.getGridParam('selrow');
                       rp_ge.url = urlEditDetail + '/' + sel_testcluster_id;
                   }},
                  // Add options:
                  {onclickSubmit: function(rp_ge, postdata) {
                       var sel_testcluster_id = grid.getGridParam('selrow');
                       rp_ge.url = urlEditDetail + '/' + sel_testcluster_id;
                   }});

So you add onclickSubmit in Edit/Add navigation bar of the Detail grid. If the event take palce, you get Id of from selected row of Master grid and place if either as a part of postdata or in the url like in my example.

Best regards

Oleg