jQuery Grid Plugin - jqGrid - Topic: how to populate edit form dropdown from db http://www.trirand.com/blog/?page_id=393/help/how-to-populate-edit-form-dropdown-from-db Simple:Press Version 5.7.5.3 Mike27516 on how to populate edit form dropdown from db http://www.trirand.com/blog/?page_id=393/help/how-to-populate-edit-form-dropdown-from-db#p9859 Help http://www.trirand.com/blog/?page_id=393/help/how-to-populate-edit-form-dropdown-from-db#p9859 OK - my problem again. My sample data wasn't actually matching up witht e grid data. Corrected the sample dropdown values and voila - works like a charm. I am really digging jqgrid. I will use this a lot.

Mike

]]> Fri, 18 Sep 2009 11:12:14 +0300 Mike27516 on how to populate edit form dropdown from db http://www.trirand.com/blog/?page_id=393/help/how-to-populate-edit-form-dropdown-from-db#p9856 Help http://www.trirand.com/blog/?page_id=393/help/how-to-populate-edit-form-dropdown-from-db#p9856 OK - I've got it populating the dropdown with the following format (found it on another topic):

           return "<select><option value='1'>Sideboom</option><option value='2'>Truck</option><option value='3'>Car</option></select>";

I also removed the formatter: 'select' from my column definition because I was getting 'undefined' in my grid for every row in the equip_type column.

Now my issue is getting the dropdown to have the correct selection in it on edit. It comes up with the dropdown unselected. Any suggestions much appreciated.

Thanks.

]]> Fri, 18 Sep 2009 10:03:45 +0300 Mike27516 on how to populate edit form dropdown from db http://www.trirand.com/blog/?page_id=393/help/how-to-populate-edit-form-dropdown-from-db#p9853 Help http://www.trirand.com/blog/?page_id=393/help/how-to-populate-edit-form-dropdown-from-db#p9853 Hello - I am trying (desparately) to fill my edit form dropdown from a db call (LINQ specifically). I can't seem to get the format it likes because my dropdown always comes up empty. I know I'm hitting my controller code because I'm setting a break point in it and hitting it. As a test I am bypassing the db call and just passing back a string I think should work but is not . Please any suggestions much appreciated.  I could not find in the doc the format it is looking for. Here's my code:

Controller:       

public string GetTypes()
        {
          
            string strRet = "";

           
            return "1:Sideboom;2:Truck;3:Car";
           
        }

aspx:

    jQuery(document).ready(function() {
        jQuery("#sandgrid").jqGrid({
        url: '/EquipTrack/GridData/',
            editurl: '/EquipTrack/Edit/',
            datatype: 'json',
            mtype: 'GET',
            height: 255,
            width: 755,
            rowNum: 5000,
            colNames: ['ID', 'Type', 'Make', 'Model', 'Year', 'Location', 'Insp Due', 'Serv Due', 'Miles/Hrs', 'Milage Dt', 'Reg By', 'Mngd By', 'Tag Exp',''],
            colModel: [
                   { name: 'equip_id', index: 'equip_id', width: 65, editable: true },
                  {name: 'type_desc', index: 'type_desc', width: 130, editable: true, edittype: "select", formatter: 'select', editoptions: { dataUrl: '/EquipTrack/GetTypes'} },
                   { name: 'make_descr', index: 'make_descr', width: 80, editable: true },

.

.

.

       }).navGrid('#sandgridp',
     {}, //options
     {reloadAfterSubmit:false}, // edit options
     {reloadAfterSubmit:false}, // add options
     {reloadAfterSubmit:false}, // del options
     {} // search options
     );
         
        $('#sandgridp_center').remove();
        $('#sandgridp_right').remove();
    });

]]> Fri, 18 Sep 2009 09:29:21 +0300