jQuery Grid Plugin - jqGrid - Topic: Select Populated from DB http://www.trirand.com/blog/?page_id=393/help/select-populated-from-db Simple:Press Version 5.7.5.3 miknight on Select Populated from DB http://www.trirand.com/blog/?page_id=393/help/select-populated-from-db#p8005 Help http://www.trirand.com/blog/?page_id=393/help/select-populated-from-db#p8005 I have a similar requirement but I need the contents of the select box to be different depending on the record being edited.

I tried calling

jQuery(grid).setColProp('link_to', {editoptions: {value: new_opts}});

before firing

jQuery(grid).editGridRow(…)

However, this only worked for the first call. Subsequent calls for other records would not change it.

I tried editing the SetColProp() function to make the extend a deep copy:

$.extend(true, this.p.colModel[i],obj);

but this still didn't fix the problem.

Edit: I was able to fix this by adding

recreateForm: true

to

jQuery(grid).editGridRow(…)
]]> Thu, 23 Jul 2009 23:53:45 +0300 Renso on Select Populated from DB http://www.trirand.com/blog/?page_id=393/help/select-populated-from-db#p7626 Help http://www.trirand.com/blog/?page_id=393/help/select-populated-from-db#p7626 Answering my own post, 3.5 Beta, I am not there yet.

]]> Thu, 02 Jul 2009 07:43:42 +0300 Renso on Select Populated from DB http://www.trirand.com/blog/?page_id=393/help/select-populated-from-db#p7625 Help http://www.trirand.com/blog/?page_id=393/help/select-populated-from-db#p7625 dataUrl? What version of jqGrid, and examples?

]]> Thu, 02 Jul 2009 07:38:38 +0300 casperd on Select Populated from DB http://www.trirand.com/blog/?page_id=393/help/select-populated-from-db#p7616 Help http://www.trirand.com/blog/?page_id=393/help/select-populated-from-db#p7616 Yeah, I used dataUrl, and it works 100%!

Thanks!

]]> Thu, 02 Jul 2009 04:54:19 +0300 tony on Select Populated from DB http://www.trirand.com/blog/?page_id=393/help/select-populated-from-db#p7609 Help http://www.trirand.com/blog/?page_id=393/help/select-populated-from-db#p7609 Hello,

Thanks Renso.

Also the new option dataUrl can be used too - which I recommend.

Regards

Tony

]]> Thu, 02 Jul 2009 03:34:09 +0300 Renso on Select Populated from DB http://www.trirand.com/blog/?page_id=393/help/select-populated-from-db#p7580 Help http://www.trirand.com/blog/?page_id=393/help/select-populated-from-db#p7580

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. If you do not set it to false, the grid will completely render before the data has retuened and the drop down box wil be empty.

    //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

]]> Wed, 01 Jul 2009 16:43:17 +0300 casperd on Select Populated from DB http://www.trirand.com/blog/?page_id=393/help/select-populated-from-db#p7577 Help http://www.trirand.com/blog/?page_id=393/help/select-populated-from-db#p7577 I need to have the selects in my grid to be populated from my databases. So, when the user clicks on the cell to edit, the select should have values from a lookup table in my database. Does anyone have an example like this?

]]> Wed, 01 Jul 2009 09:31:40 +0300