Forum

November 2nd, 2014
A A A
Avatar

Lost password?
Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

The forums are currently locked and only available for read only access
sp_Feed Topic RSS sp_Related Related Topics sp_TopicIcon
jqGrid + dropdown lists + asp.net MVC
13/10/2011
12:45
Avatar
chandinipt
New Member
Members
Forum Posts: 2
Member Since:
13/10/2011
sp_UserOfflineSmall Offline

Hi,

Can somebody help me resolve an issue I am having with jqGrid and dropdown lists please?  I have looked at the questions on SO but the solutions do not help me.

I have two drop down lists - category and subCategory.  I want the subCategory value to be dependent on the category.  I am using Form-based editing
    I can get this working in the following cases no problem
- when i am adding a new row, the drop downs work fine.  SubCategory is initially set to just the 'Select' string and when I select a category, the subcategory values are correctly updated.
- ****I create any new row**** and then go back in my grid, click on any other row to edit the data, the subCategory value is correctly displayed from the database. 

  If however, I go into my page and just try to edit a row in the form (without first creating a new row), the subcategory is not set correctly from the database.  And just shows up empty.  I have tried using dataInit on both fields but it doesn't even fire!!!! 

These are the relevant code lines. 
jqGrid View:-

            { name: 'categoryId', index: 'categoryId', width: 100, align: 'left', sortable: true, editable: true, edittype: 'select',
                editoptions: { dataUrl: '/Admin/GetCategories',
                    dataEvents: [
                        { type: 'change',
                            fn: function (e) {
                                var v = $(e.target).val();
                                setSubCategory(v);
                            }
                        }
                         ]
                },
                editrules: { edithidden: true }, searchtype: "text", searchoptions: { sopt: ['cn', 'eq', 'ne', 'bw', 'ew', 'nc'] }
            },
            { name: 'subCategoryId', index: 'subCategoryId', width: 100, align: 'left', sortable: true, editable: true, edittype: 'select',
                editoptions: { dataUrl: '/Admin/GetSubCategoriesForCategory' },
                editrules: { edithidden: true }, searchtype: "text", searchoptions: { sopt: ['cn', 'eq', 'ne', 'bw', 'ew', 'nc'] }
            }....

    function setSubCategory(category) {
        $.ajax({
            url: '/Admin/GetSubCategoriesForCategory',
            data: { 'categoryId': category },
            type: 'GET',
            dataType: 'html',
            success: function (data) {
                $("#subCategoryId").html(data);
            }
        });
    }

And my controller action

    public string GetSubCategoriesForCategory(int? categoryId)
    {
        if (categoryId == null)
            return GetEmptySelect();   //Just returns a Select with no options

        StringBuilder result = new StringBuilder();
        result.Append(defaultVal);  //this is the 'Select' option
        if (categoryId != null)
        {
            foreach (var c in db.categories.Where(c => c.parentID == categoryId).ToList())
            {
                result.Append("<option value=" + c.ID + " > " + c.desc + " </option> ");
            }
        }
        return result.ToString();
    } 

As I mentioned before, I did try using the dataInit on categories to set the dataUrl of the sub-categories, but I keep getting an undefined value instead for some reason. 

P.S:- Not sure if this is relevant or not, but I cannot get many of the events to fire in the jqGrid.  I also cannot get the cell editing to work either, just freezes the grid and I cannot select any row etc.  I'm using IE8.

Thank you

Forum Timezone: Europe/Sofia

Most Users Ever Online: 715

Currently Online:
15 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

OlegK: 1255

markw65: 179

kobruleht: 144

phicarre: 132

YamilBracho: 124

Renso: 118

Member Stats:

Guest Posters: 447

Members: 11373

Moderators: 2

Admins: 1

Forum Stats:

Groups: 1

Forums: 8

Topics: 10592

Posts: 31289

Newest Members:

, razia, Prankie, psky, praveen neelam, greg.valainis@pa-tech.com

Moderators: tony: 7721, Rumen[Trirand]: 81

Administrators: admin: 66

Comments are closed.
Privacy Policy   Terms and Conditions   Contact Information