We have here a lot of possible solutions.
1. Setting the values direct via script – here is PHP example:
When you call the page with a grid – call it as php page and not as html
colModel [{….
{name:”mayname”…editable:true,edittype:”select”,
editoptions:{''}…},
…
]
where the variable $myeditoptions holds the values from the db
This is the recommendet solution. If this is not possible
2. We can use the method from previous post. We can cal this after the grid is constructed.It is not too late – why?
$.get(”myurl”,data:mydata,function(result,status){
if (status == “success”) {
// get the result here, suppose that in myselect are the values
$(”#mygrid”).setColProp(”myname”,{editoptions:{myselects}});
…
}
}
3. Another possible solution is to use the userData in jqGrid –
(this is another elegant solution). See userData examples haw to do that.
Then
loadComplete : function() {
// get the userData here and convert it to format supported
// in colModel then the same tehchniquie as from 2
$(”#mygrid”).setColProp(”myname”,{editoptions:{myselects}});
…
}
~Enjoy
Tony
