jQuery Grid Plugin - jqGrid - Topic: change Navigator url / form editing parameters dynamical

OlegK on change Navigator url / form editing parameters dynamical

Sun, 19 Sep 2010 12:41:27 +0300

Hi Jack,

I am glad to hear that I could help you. The RowVersion was really needed in the exmple for the optimistic locking. I took the example from the project where the data will be hold on the Microsoft SQL Server and every row in the database has additional column with the non-nullable value of the type timestamp (http://msdn.microsoft.com/en-u.....82776.aspx for details).

On every Edit operation in the jqGrid the value from the RowVersion will be send to the server automatically because the RowVersion column I defined with

hidden: true, editable: true, editrules: { edithidden: false }, hidedlg: true

option. So the value could be used for the optimistic locking. To use RowValue also in Delete operation I had to add the RowValue manualy inside of onclickSubmit as I described befor.

Best Regards
Oleg

slowjack2k on change Navigator url / form editing parameters dynamical

Sun, 19 Sep 2010 10:15:22 +0300

It works very well

I made only one minor change insteed of a temporary urlEdit variable I use:

jQuery("#grid_id").jqGrid('getGridParam','editurl')

You need RowVersion for optimistic locking, right?

slowjack2k on change Navigator url / form editing parameters dynamical

Sun, 19 Sep 2010 10:02:09 +0300

Thank you Oleg. You'r right. It isn't nessecary to change mtype dynamical. You'r example will serve me quite well. It's exactly what I was looking for.

Regards

Jack

OlegK on change Navigator url / form editing parameters dynamical

Sun, 19 Sep 2010 01:25:12 +0300

First of all you should remove comma after the refresh: "refresh:true,}" if you have the same problem in your code.

Now to your question. The requirement to use different mtype values I understend good, but having mtype absolute dynamic I don't understend.

You can overwrite url dynamicaly inside of onclickSubmit function. For example below you can find an example from one of my scripts:

jQuery("#gird").jqGrid('navGrid','#pager_id',
                               {edit:true, add:true, del:true, search:true, refresh:true},
         { mtype: "PUT",
            onclickSubmit: function(rp_ge, postdata) {
                rp_ge.url = urlEdit + '/' + postdata.list_id;
            }
         },
         { mtype: "POST" },
         { mtype: "DELETE",
           onclickSubmit: function(rp_ge, postdata) {
                    rp_ge.url = urlEdit + '/' + postdata +
                                '?RowVersion=' + grid.getCell (postdata, 'RowVersion');
                }
         }

The variable urlEdit I define somewhere before. I hope you could use the example to write the code in your case.

Best regards
Oleg

slowjack2k on change Navigator url / form editing parameters dynamical

Sat, 18 Sep 2010 17:08:47 +0300

Hello,

is it possible to change edit, add, del url and mtype dynamical, or use a function?

I would like something like this:

jQuery("#gird").jqGrid('navGrid','#pager_id', {edit:true,
                                               add:true,
                                       del:true,
                                               search:true,
                                               refresh:true,
                                          }, {url : function(original_url){ return new_url; } mtype: function(original_mtype){return new mtype;}}

Or can I change parameters for form editing after add-button and so on was pressed?

Regards

Jack