I've got a master/detail pair of grids. There is a parent key(actually 2 fields) in the detail grid, referring to the corresponding row in the master grid. In the detail grid, I have these fields hidden and not editable.
When adding or editing a row, neither field is included in the data sent to the server. Here's the code for the detail table:
The fields tdr_td_DB and tdr_td_Name are the fields that link back to the parent table. I tried adding onClickSubmit, which doesn't seem to ever be called. I've been testing with "alerts" in that code than never show up.
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.
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:
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.
But the problem is that when jqGrid sends the added row to the server, the data has to include the key of the master table row.
For Example:
Master data:
ID, DBName, TableName, Description
In this case, ID is a unique ID for the Master table
Detail Data:
ID, Master_DBName, Master_TableName, FieldName, FldType, etc.
In this case, ID is a unique ID for the Detail table
Where DB_Name = Master_DBName and TableName = Master_TableName
When jqGrid adds a row, Master_DBName and Master_TableName are blank (as with all the row's fields), so I need to be able to insert the proper key from the master grid/table. Otherwise, the asp file on the server won't know which master record to associate with the detail row.
In other words, I need to populate the fields before the data is sent to the server.
Also, I'll need to get the value(s) of the parent key fields of existing rows in order to figure out the value to put into these parent key fields. I saw an XML example where user data was passed outside the rows, in the same area where things like the page number and such are located. That might be the way to pass the parent key to the grid. (all rows in the detail grid would have the same parent keys).
Sorry to be so slow, and thanks for your patience!
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,
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.
Login 
Register 
Search 
Forum
Print this Post 
Topic RSS 
