jQuery Grid Plugin - jqGrid

I used the setCell() functionality that Tony mentioned on his original response (BTW, thank you Tony!).

I obtain the data on the server side throught a separate JSON request and I check for malformed cells in there.  I am pretty sure you can do it if you are obtaining the data directly through the jqGrid.  I then have a return data structure which is an array containing entries of the form: {message: "my message", rowId: row, cellId: cell}.  Remember rowId is what you have set your ID to be or if you have not set anything its an iuncremental number.  Cell Id is also what you have specified as name is the colModel.

I first set the grid in JavaScript and then iterate through the forementioned data structure to highlight the malformed entries.  Here's the code:

...
// Create the preview grid
jQuery("#gridErrorPreviewTable").jqGrid({
datatype: "local",
height: "100%",
colNames: response.data.colNames,
colModel: response.data.colModel,
pager: '#pagerErrorGridPrevieTable',
viewrecords: true,
caption: 'Import File Preview'
});
// set the pager
jQuery('#gridErrorPreviewTable').jqGrid('navGrid','#pagerErrorGridPreviewDiv', {edit:false,add:false,del:false,search:true});

// add the data
for (var i = 0; i <= response.data.rows.length; i++) {
jQuery("#gridErrorPreviewTable").jqGrid('addRowData',i + 1, response.data.rows[i]);
}

for(var i=0;i<response.errorMessages.length;i++) {
var rowId=response.errorMessages[i].rowId;
var cellId=response.errorMessages[i].cellId;
jQuery("#gridErrorPreviewTable").jqGrid('setCell',rowId,cellId,'',{color: 'yellow',background: 'red'});
}
...

I hope it helps you newperson 🙂

George

Alright I think you need to go back to the wiki and read the introductory material on jqGrid.   All the response.* you see such as  response.errorMessages are data specific for my application. 

Maybe what you need to do is add a handler for a loadComplete event.  In the body you can use the getRowData and setRowData to check for the value you are interested and to update the CSS for the rows you would like to highlight.

I am also fairly new to jQuery, jqGrid, etc. so maybe looking into the formatter Tony mentioned in his second post may worth your while.

Again I would suggest you look into the introductory material and understand how jqGrid works--I assure you this investment will re-pay you multiple times. 🙂

George.