weinhorn on jqGrid dynamically build

Tue, 23 Jul 2013 11:02:01 +0300

Ok, I have now solved itself. The Colmodel was present as a string, it must be prepared again:

var colmodel = "[";
                    for (x = 0; x < cmodel.length; x++) {
                        colmodel += cmodel[x] + ",";
                    };
                    colmodel = colmodel.slice(0, -1);
                    colmodel += "]";

And then eval(colmodel);

weinhorn on jqGrid dynamically build

Fri, 19 Jul 2013 09:48:35 +0300

Hello!
I've registered here because I have a little problem.
I want to build my jqGrid dynamically. All values â€‹â€‹come from the SQL DB. The table is set up correctly, just does not the paging, sorting and filtering. When I enter my colmodel directly in the script, then everything works. So the string looks in the database for each field:

ID colModel (column in DB, text)
—————————
1 name: 'ID', index: 'ID', width: 60, sorttype: 'int'
2 name: 'Title', index: 'Title', width: 90, align: 'right', search: true, searchoptions: { sopt: ['cn']}
…

And here is a part of the script on the client side:

        function loadGrid() {
            $.ajax({
                type: "POST",
                url: siteName + "/_vti_bin/IntranetWCFcustomService/myWCFservice.svc/getSettingForJqGrid?serverName=" + serverName + "&dbName=" + dbName + "&tableName=" + $("#tableName").val() + "&viewsID=" + $("#viewsID").val() + "&formID=" + $("#formID").val(),
                dataType: "json",
                success: function (response) {
                    var gridName = response[0]["Titel"];
                    var cnames = response[0]["ColNames"];
                    var cmodel = response[0]["ColModels"];
                    var rowNum = response[0]["RowNum"];

                    jQuery("#list_inventory").jqGrid({
                        url: siteName + "/_vti_bin/IntranetWCFcustomService/myWCFservice.svc/getSqlData?serverName=" + serverName + "&dbName=" + dbName + "&tableName=" + $("#tableName").val() + "&viewsID=" + $("#viewsID").val() + "&formID=" + $("#formID").val(),
                        datatype: "json",
                        height: $("#<%=_ClientID.Text %>_heightValue").val(),
                        autowidth: true,
                        rowNum: rowNum,
                        rowList: [10, 20, 30],
                        colNames: cnames,
                        colModel: cmodel,
                        pager: "#plist_inventory",
                        viewrecords: true,
                        sortname: 'ID',
                        sortorder: 'ASC',
                        onSelectRow: function (ID) { getDetails(ID); },
                        caption: gridName,
                        toolbar: [true, "top"]
                    }).navGrid('#plist_inventory', { edit: false, add: false, del: false, search: false });
                    jQuery("#list_inventory").jqGrid('filterToolbar', { stringResult: true, searchOnEnter: false });
                },
                error: function (response) {
                    alert(response.responseText);
                }
            });
            return false;
        }

Where can the problem be then? If I would have my ColModel string in the wrong format, I would get an error message that COLNAMES and CoModel have different lengths. I do not get this message.
I'm sorry for my English!

Sincerely yours
wolfgang

jQuery Grid Plugin - jqGrid - Topic: jqGrid dynamically build

weinhorn on jqGrid dynamically build

weinhorn on jqGrid dynamically build