jQuery Grid Plugin - jqGrid - Topic: Dynamic select combo to a field in Edit Form

Renso on Dynamic select combo to a field in Edit Form

Sat, 15 Nov 2008 17:30:15 +0200

Quite simply actually, I do it with all my selectables:

Do this before you define the jqGrid and make sure async is set to false.

//get all products
var products = $.ajax({url: $('#ajaxAllProductsUrl').val(), async: false, success: function(data, result) {if (!result) alert('Failure to retrieve the Products.');}}).responseText;

The define your grid:

    $(item)
        .jqGrid({
            url: listURL,
            postData: {ContractId : $('fieldset#ContractDetails #ContractId').val()},
            datatype: "json",
            colNames:['Id', 'Product Name'],
            colModel:[
                {name:'Id',            index:'Id', sortable:true, editrules:{edithidden:false}},
                {name:'ProductName',   index:'ProductName', sortable:true, required:true, editable:true, edittype:"select", editoptions:{value:products}, editrules:{required:true}}],

You can also do it on the loadComplete event by using setColProp, which I do in some other cases as if you are going to have modal boxes for editing it will generate a runtime error if you do not have it set the following way:

loadComplete: function() {$(item).setColProp('ProductName',{editoptions:{value:products}});

By the way "item" is the id of the grid. Hope this helps

tony on Dynamic select combo to a field in Edit Form

Wed, 22 Oct 2008 02:49:19 +0300

Hello,

I will try to add this in next release. For now you can use a combination of loadComplete event again with setColProp to add extra fields of the select dynamically.

Regards

Tony

Prathap MK on Dynamic select combo to a field in Edit Form

Wed, 22 Oct 2008 02:36:35 +0300

Hii,

How can i use data to be populated to a field of edittype: select, from database instead of using editoptions: {value: some values}. I cannot hardcode these value and has to populate from database. How can i do this?

Since surl can be used only with filter grid, i cannot use that too.

Thanks in advance.

Regards,
Prathap.