jqgrid

JQGrid sorting on client side

I have tree-grid with autoloading nows. The goal is to sort the grid by tree column, right on client side. But each time I click on sort column header, it issues ajax call for sorting – but all I need is on-place sorting using the local data. Do I have incorrect grid parameters or tree doesn't work with client-side sorting on tree colu...

Sorting, Filtering and Paging in ASP.NET MVC

What is the best approach to implement these features and which part of project would involved? I see some example of JavaScript grids, but I'm talking about a general approach which best fits the MVC architecture. I've considered configuring routes and models to implement these features but I don't have a clear idea that if this is th...

jqgrid format column dynamically

I am trying to format a jqgrid which has some dynamic columns which I create like this JQGridColumn column1 = new JQGridColumn() { DataField = "ID", PrimaryKey = true }; ErrorsJQGrid.Columns.Add(column1); How do I format these columns to have a say 'yellow background color'? I can specify a in th...

JQGrid tree - passing additional parameters when tree is expanded

I have a JQGRid tree. It loads data click by click, not all at once. Typically, JQGRid passes 4 standard tree parameters with each call - row (level, parent, is leaf, is expanded). How can I pass more parameters that I will take from the row being expanded? E.g. data from Name column should be passed in AJAX call too. There doesn't seem...

Tutorials and resources on jqgrid and flexigrid

Hi Am currently trying to use for the first time both jqgrid and flexigrid to make database driven pages whos backend uses Zend Framework. I have been googling and the search results that turn up aren't very helpful. Any links that can be helpful? ...

Is it possible to Stop jqGrid row(s) from being selected and/or highlighted?

I've looked at the documentation but I've been unable to find an answer. Is there a way to prevent a row from being highlighted when selected? That or even a way to stop the row being selected at all. I like the "hoverrows: true" option, but ideally I would like to stop a row from being selected on-click. Thanks, Update: I've been...

How do I add datepicker in the add row dialog in jqGrid?

Hi I'm using jqGrid and I'm wondering, how do I add jQueryUI's datepicker to some of the input fields when in the add row dialog? Also how do I check if the input entered are valid? Thanks in advance! ...

jqgrid in MVC not working

Hi Am currently learning how to use jqgrid in Zend MVC structure. Below is my js script. $(function() { //tabs $("#tabs").tabs(); //Accordion $("#accordion").accordion({ header: "h3" }); //place jqgrid in accordian. $("#list1").jqGrid({ url:'/../../artist/index', datatype: "json", colNames:['ID','Artist...

Understanding JQGrid column width behaviors

I have a tree grid with many columns, all with specified width. And boy, it looks terrible since headers are out of synch with columns below, even if I have short data in them. Specifically, if column Header title is shorter than this column width, Header shrinks down to the the size of text in header. How can I make header be exactly ...

how to check the state of the row in jqGrid

i whant to check if the row is in edit mode. i've checked the jqGrid documentation but i couldn't find this. thanks in advance ...

Getting a jqgrid action helper to work

Hi After a few searches I came across a jqgrid action helper that I could include into my Zend MVC. However after downloading the source and trying to use it I get this error Fatal error: Call to a member function getActionController() on a non-object in ..... \Controller\Action\HelperBroker.php on line 299 Here is an excerpt of the ...

php + jqgrid + export to excel

Somebody knows a way to export the data from a jqgrid to excel? I want to do a report using this jqgrid that i think is awsome. But i need to save or print this report somehow, because is information to be keeped. Somebody knows any way?? ...

JqGrid updating grid on add

Scenario: I have three columns in my grid but only one is editable, the other two are filled in on the server side. I am using the built in add functionality of jqGrid and NOT refreshing the grid on successfully add. I would like to have the row added to the grid, like it does automatically, but would like to add it myself because it ...

Jqgrid: how to allow editing for some record and not for others

<table id="gridmain"></table> <div id="pagermain"></div> I enabled all Form updating by putting: (Add:true,Edit:true,Delete:true) But for some records with say: records with the field ConfirmFlag = 1 (the column id is "ConfirmFlag") , I will like to set it such that Editing is not possible (ie, Edit form do not open and possible a dia...

jqGrid - How to delete associated tables?

Is it possible using jqGrid to load data from a table (parent table) but when I want to delete a record, it should first delete the associated records in the child table, because of the Foreign Key constraint. If yes, how to do that. Thanks! ...

setting JQGrid RowNum dynamically.

Hi, I am facing an issue when using JQGrids. I have a JQGrid whose rowNum is set to 10. I have this code in my javascript: rowNum: 10, height: 160, width: 742, shrinkToFit: false, sortname: 'CreditRequestID', sortorder: "asc", viewrecords: true, Now my source for populating the grid is in the model. So say my model.SearchResults has ...

jqGrid - Undefined index: native_type ...eval()'d code on line 1..

I got this error! Undefined index: native_type in C:\wamp\www\avr\php\jqGridPdo.php(1) : eval()'d code on line 1.. This works fine in my machine but when I upload and test it in the linux server I got the error message (the grid works perfectly though)...Am I missing any configuration here..? The codes can be found here...http://www.t...

ASP.NET MVC and jqGrid: Persisting Multiselection

I have a jqGrid in an ASP.NET MVC View with the option multiselect:true. There are over 200 records displayed in the grid, so I have paging enabled. This works great, but when I navigate from page to page, the selections are lost when I navigate. Is there a good, clean way to persist the selections so that they are maintained while pa...

jqGrid - Table not being populated by data from json request

Hi, I am trying to get a grid displayed using jqGrid. Everything seems to work fine. The table is being render, but all the cells are empty. All the other infos are on the table (page number, total pages, number of rows). When trying to change page, the json data is being retrieved without any problem. Here is a snip of my code: <scri...

getChangedCells is returning [object, Object)

I am using jqgrid with edit cell options. Both methods getRowData and getChangedCells returning [object, Object]. Please help what could be problem. ...