jQuery Grid Plugin - jqGrid - Forum: jqGrid Roadmap

bcarpenter on MVC4 and jqGrid

Thu, 28 Mar 2013 23:10:43 +0000

I have an MVC4 project and I am trying to follow the MVC3 example and I cannot get the grid to render. On the MVC3 project example it runs fine but on the MVC4 project in the Chrome browser console I get the following message:

Uncaught ReferenceError: jQuery is not defined Also in the MVC 3 project the Grid is rendered as

"<div class='ui-jgrid ui-widget ....ect." where on the MVC4 it is rendered as "<table id="JQGrid1"></Table>

TIA

Bruce Carpenter

sriramojusrikanth on how to export Jqgrid data to csv file in java

Tue, 26 Mar 2013 12:11:10 +0000

sir,

I need , how to export jqgrid data to csv file in java

rajeshreddythr on JqGrid Popup (Add/Edit)

Thu, 28 Feb 2013 14:59:27 +0000

Hi all

I have got 4 Jqgrids(G1,G2,G3,G4) in my page in Four tabs(T1,T2,T3,T4).Whenever i open a Add/Edit popup of Jqgird G1 and switch to G2 in T2 then the popup is not getting closed.

Wish to get ideas for this.

What i am thinking of is ,if i can blur out rest of my page whenever i open any Add/Edit Popup in any Grid then this would'nt let user to switch to other Tabs.

So,

May i know how can i blur out the rest of the page when i open an Add/Edit popup in jqgrid.

I am using jqGrid 4.4.1 .

Rajesh.

klaudyuxxx on npage parameter from prmNames

Thu, 28 Feb 2013 12:13:21 +0000

Hello,

I have a grid which is using virtual scrolling to load data . Everything works as expected, but I can't make it load ahead with the npage parameter from prmNames. The info in documentation is ambiguos. What type of data is it, how does it work? I gave it some int values from 1 to 10 but it doesn't have any effect.

GeorgeG on Paste data from excel into JqGrid

Fri, 08 Feb 2013 18:28:30 +0000

Hello beatrizpereira,

I had to do something similar on a project. My workaround was to use a textbox input to store the data temporarily and then write a bit of javascript to process the data in the textbox.

A bit ugly, but worked for me.

I will try to get some code in here later on.

Cheers,

GeorgeG

pelirr on jqgrid no click field

Fri, 01 Feb 2013 16:14:32 +0000

Hello, I am trying to remove an event from a field, and I know not how. I am using jqGrid. I have a form field that is read-only, but in which I can click with the cursor. What I want is that the user can not click on the field, the same thing happens when you disable a select, do not let not even click on it. I've been looking online, examples to disable the event, with

event.preventDefault () or. unbind ("click"),

but I have not received results. I do not know even if I have to disable the event, or is there some property that allows me to do what I want. For example, if I want I can change the style attribute or property access style:

$ ('# FlightNumber', formid). attr ('style', 'border: # AFAFAF; color: # 6D6D6D');

if you want to hide the field:

jQuery ('# tr_flightNumber', formid). hide ();

I do not know how to do what I want.
Could someone help me out? The field in question is of type textfield.

Thank you very much, greetings

ayyanarj on Memory Leak problem in JQ Grid for IE 9

Mon, 24 Dec 2012 09:41:28 +0000

Hi,

I think, previouis post is vague to understand the problem. So, i'm trying to explain with more details.

I have a page with tabs. In each tab, i'm loading the jQGrid. When switching to different tabs, previous tab grid is destoyed by following method.

$('#jqTable').jqGrid('GridDestroy');

But still, memory is not reclaimed completely. I am seeing some memory leaks every time when i am destroying and loading new grid. 
So, to reclaim memory completely, what should I do?

NOTE: Problem  in IE Version.

Thanks
Ayyanar

ayyanarj on Memory Leak problem in JQ Grid for IE 9

Mon, 17 Dec 2012 13:18:53 +0000

Hi,

Requirement:

I have vertical (LHS) and its related horizontal tab (RHS) menu. For every RHS tab click, i have to call back end and load the JQ Grid. When switching to new RHS tab, old RHS tab grid will be stored in DIV (seperate div for storing grid) data.

When switching to new LHS tab, all RHS tab data of previous LHS tab should be cleared.

Issue:

whenever switching to new LHS tab, i am removing event and data of all RHS tab of previous LHS. When i am clearing, memory is not reclaimed. So, every LHS click, memory is getting increased. I want to reduce the memory usage for every LHS click.

Please help me to resolve this issue.

Thanks

Ayyanar

40ba

adondero@gmail.com on Controlling row Height.

Thu, 08 Nov 2012 20:47:47 +0000

I have an issue with my grid that I am not sure how to fix. Some of my columns have custom HTML in them so that I can have a two rows of data in the grid.

As I add new rows, the issue appears when the new row is not visible. JqGrid scrolls to show the first line of the row.

Are there any properties to set to tell it to scroll and additional "x pixels", or that my row is 2 rows in height?

Any thoughts or ideas would be helpful.

tony on Optimize JQ Grid Loading - How to reduce the Loading Time?

Wed, 31 Oct 2012 13:45:54 +0000

Hello,

This not correct. Just call clearGridData WITHOUT to use trigger("reloadGrid");

While the data is deleted you reload the data again which causes the problem.

Insted if you want to use reloading you will need to call reloading only within setTimeout function.

Regards

Arvind Yadav on Arabic and Chinese characters are not displaying properly in jqgrid

Wed, 31 Oct 2012 11:38:49 +0000

Hi,

Are you still facing the issue.

How are you sending the data in a ajax request?

And also, set the response content type at the correct place.

regards

Bommannan.R on Optimize JQ Grid Loading - How to reduce the Loading Time?

Wed, 31 Oct 2012 11:00:01 +0000

Thanks Oleg for the quick response. It worked and reduced the grid load time. But, sort time still takes more time. Is there any configuration for reducing the sort time?

Also, is there any method to delete all the rows from the grid. currently we are using $grid.clearGridData().trigger("reloadGrid") ? While we are using clearGridData() method, browser throws the below warning:

Stop running this script?

A script on this page is causing your web browser to run slowly. If it continues to run, your computer might become unresponsive.

OlegK on Optimize JQ Grid Loading - How to reduce the Loading Time?

Tue, 30 Oct 2012 13:12:45 +0000

Hi!

You should use data option of jqGrid and create the grid with all the data in one operation. Usage of addRowData is slower bacause it insert the data in the grid row after the row. Every inserting of the row follows recalculation of position of all other exsiting element on the page or at least to reflow (see here for more details).

Usage of data option event without virtual scrolling (without scroll: true) should get you much performance impronement. It's important to continut to use gridview: true which you already use now.

If you need to update contain on existing grid you can use getGridParam("data") to get the reference to the internal data parameter, then you can change it by direct assignment and trigger reloadGrid event.

Best regards
Oleg

Bommannan.R on Optimize JQ Grid Loading - How to reduce the Loading Time?

Tue, 30 Oct 2012 10:16:38 +0000

Hi All,

As a project requirement, there are 5 grids in a page. I tried by loading one JQ grid using Array data load with 1000 records containing 1 checkbox column and 7 text columns.

For loading 1000 records, JQ grid takes 3 seconds in 4GB RAM system and 20 seconds in 2GB RAM system

Is there any configuration can be done, in order to reduce the load time?

Highly appreciate your value add comments & suggestions.

Here is the code I'm using:

var JQGridTest = JQGridTest || {};

JQGridTest.PersonGrid = (function () {
var $PersonGrid;

    var init = function () {
        $PersonGrid = $("#PersonGrid").jqGrid(buildpersonGridInitObject())
    };

    var addPersonDetails = function () {
        var data = [];
        for (var i = 0; i < 1000; i++) {
            data[i] = {
                PersonNumber: "P " + i,
                BDate: "01/01/" + i,
                JobStatus: "Working",
                JobStatusValue : "WKNG",
                DEPT: "DEPT " + i,
                JobDescription: "Job " + i,
                MinExp: i,
                MaxExp: i,
                PersonDbKey: i,
                Person_Person_DbKey: i + i
            };
        }

$PersonGrid.addRowData("Person_Person_DbKey", data, "last");
};

    var buildpersonGridInitObject = function () {
        return {
            datatype: "local",
            scroll: true,
            height: 500,
            autowidth:true,
            width: 945,
            shrinkToFit: false,
            multiselect: true,
            sortname: "PersonNumber",
            loadonce: false,
            sortable: true,
            altRows: true,
            altclass: "alternateRow",
            rowNum: 10000,
            gridview: true,
            colNames: [
                        "Person number",
                        "birth date",
                        "JOB Status Value",
                        "JOB status",
                        "DEPT",
                        "Job description",
                        "min exp",
                        "max exp",
                        "Person DbKey",
                        "Person_Person_Dbkey"
                      ],
            colModel: [
                        { name: "PersonNumber", index: "PersonNumber", sortable: true, width: 80, align: "center", sorttype: "text" },
                        { name: "BDate", index: "BDate", sortable: true, sorttype: "date", width: 80, align: "center", sorttype: "date" },
                        { name: "JobStatus", index: "JobStatus", sortable: true, hidden: true, sorttype: "text" },
                        { name: "JobStatusValue", index: "JobStatusValue", sortable: true, width: 80, align: "center", sorttype: "integer" },
                        { name: "DEPT", index: "DEPT", sortable: true, width: 100, align: "center", sorttype: "text" },
                        { name: "JobDescription", index: "JobDescription", sortable: true, width: 368, align: "left", sorttype: "text" },
                        { name: "MinExp", index: "MinExp", sortable: true, sorttype: "integer", width: 80, align: "center" },
                        { name: "MaxExp", index: "MaxExp", sortable: true, sorttype: "integer", width: 80, align: "center" },
                        { name: "PersonDbKey", index: "PersonDbKey", sortable: true, hidden: true, sorttype: "integer" },
                        { name: "Person_Person_DbKey", index: "Person_Person_DbKey", key: true, sortable: true, hidden: true, sorttype: "text" }
                      ]
        };
    };

    return {
        init: init,
        addPersonDetails: addPersonDetails
    };

})();

Calling jQuery Code:

$(document).ready(function () {
    JQGridTest.PersonGrid.init();
    $("#selectMinMax").click(function () {
        var d1 = new Date();
        JQGridTest.PersonGrid.addPersonDetails();
        var d2 = new Date();
        var d3 = (d2 – d1);
        var seconds = Math.round((d2 – d1)/1000)
        $("#loadTime").text(d3 + " , " + seconds);
        //alert(d3);
    });
});

HTML:

Thanks,
Bommannan.R

167e

GridLearner on Arabic and Chinese characters are not displaying properly in jqgrid

Thu, 11 Oct 2012 17:24:12 +0000

Hi Tony,

Thanks for your response. I am using Java to get json object. I have set like this,

final HttpServletResponse response = (HttpServletResponse) facesContext .getExternalContext().getResponse();

response.setContentType("application/json; charset=utf-8");

Still is not working.

tony on Arabic and Chinese characters are not displaying properly in jqgrid

Thu, 11 Oct 2012 17:18:35 +0000

Hello,

This setting is by default, so the grid has nothing to do.

1. Set the caheset with meta tag in your html page

2. When the data comes from the server be a sure you send a header with utf-8.

In PHP before to output the data do:

header("Content-type: text/xml;charset=utf-8″);

Regards

GridLearner on Arabic and Chinese characters are not displaying properly in jqgrid

Wed, 10 Oct 2012 17:37:13 +0000

Hi,

I am using JQgrid 4.4 version. I have added

ajaxGridOptions: {

contentType: 'application/json; charset=utf-8'

} this into my js file. But still the Arabic and chinese characters are not working properly.

It would be great if anyone can help me out of this problem.

abhilashg on "freeze column does not work with celledit

Thu, 04 Oct 2012 18:41:53 +0000

"I want to be able to freeze column and at the same time to edit cells not rows".

I am also facing the same issue.

I have wasted 2 days but didn't get anything.

Help will be highly appreciated.

Thanks,

Abhilash

jymuk on jqgrid columns header not aligned with columns

Thu, 20 Sep 2012 01:13:18 +0000

arc123 said:guys got a solution please add latest ui.jqgrid.css (4.0) for grid it solves my issue……………

I have the same issue here. How do you know that it is 4.0, because it doesn't say so in the ui.jqgrid.css file

brux88 on jqgrid+calculation+knockout

Sat, 15 Sep 2012 10:46:52 +0000

Hello everyone, I managed to run knockout js. example:http://jsfiddle.net/brux88/9fzG4/ . now I would like to replicate the same thing using jqGrid, but I can not run the calculations in real time. can someone help me? I also tried without using knockout, but only using jqGrid I do not work the same.example: http://jsfiddle.net/brux88/yGJcy/