jQuery Grid Plugin – jqGrid

You guys should get a prize…excellent product!

The new feature list is impressive as always. Keep up the good work!
Do you plan to update demos before releasing or publish some screenshot to preview the Steel theme?

Hello,
Demo page updated. Now you can preview how the new theme look.
Tony

The the 3.4 roadmap stated that the treegrid would support the “Adjacency List Model”. Did this get added?

Hi This is a great grid. I was making an attempt on the flexigrid but this is much superior. I am currently using this on an ASP.NET site. Addition of scroll is a good addition. Amazingly a lot of people are interested in the scroll version of the grid. I had 1 question though, is there a way/hack to freeze 1st 2 or 3 columns in the grid. I could use the expressions CSS for IE, but was wondering if you may have some other suggestions

Very cool!

@Robbie – You are right. The work on this is just in progress. I hope to finish it for the final.

@vinay – no plans for now for this, but it will be interested if you share your solution with others – for me too.

Regards
Tony

Tony another quick issue, I am using cellEdit: true, cellsubmit: ‘clientArray’ however after I am not able to set the value of the cell. The value of the cell being picked is blank. Do I have to call setCell in the afterSaveCell to set the value.
Thanks
Vinay

Tony I noticed a bug in the current release.
On using the cellEdit: true feature, for some reason if the column names have a space, then the behavior changes. It is not able to detect the editted value, and on sorting the column the arrow showing the sort order also disappears. This exists in the latest beta and stable releases. Is there a way to go around this

Fantastic Work!!!

JQuery 1.3 was released today, will jqGrid 3.4 officially support it?? Doesn’t seem to be working now. The performance numbers for JQuery 1.3 are very impressive.

Hello, very nice work guys!!!

I am using the grid in a intranet tool for my company. Is there an planed date when the final version of 3.4 would be finished?

Best Regards
Micha

The best plugin of jQuery made by you.Thanks ,Tony,you are a good man.

First, this is a very nice plug-in with an excellent feature set. Second, does anyone know if there are plans for jqGrid to work with jQuery UI Theme Roller? I noticed the jQuery team is talking about creating their own grid, but yours seems so complete it would be sad to see them try to replace it.

Keep up the great work.

Thanks for the great work!

JQuery 1.3.1 is out. When will jqGrid have official support for it?

Great work!

Hey! Great work! I LOVE this grid and the way it’s evolving. I’ve been following the development and it is probably the best open source grid out there!
And since i’m just loving it i wanted to contribute somehow.
So looking at the other grids that are out there i realized that they are no match for jqGrid regarding the features. The only chapter where jqGrid might need some polishing is the look and feel. And.. ,although it’s a pity, the looks sell. So i thought i should start building a theme that would measure up to the brilliance of this grid. This theme should be slick and nice and work with all the plugins that come with jqGrid. I’ve already finished the theme for the base grid and some basic features (multiselect checkboxes, cellEdit, toolbar).
I also wrote a few lines of code to make jqGrid resizable by mouse drag. So you can resize it by simply draging the handle (right bottom corner of the panel).

I will put an example with my theme on the web the next days and post the link here.
And about the dragresizing, I’d like to make a plugin out of it. But i have no clue how to write a plugin for jqGrid. I’d need some ‘pointing in the right direction’. Is there some documentation or a tutorial on writing a plugin for jqGrid?

Thanks!

Nice work! Thanks!

Please setup a SVN with trunk and tags at Googlecode (or somewhere else).
This will make vendor branching easier (direct link to the repository).

For those who wonder, the readme.txt mentioned above was not included in beta2. I don’t know if this was done on purpose. If anyone wants it, I can post a link to it.

Just as a suggestion, scroll=true could load data from cache passing a page size (page-size=20) such that we oass the scroll position of the div and load only the 20 rows within the passed indices. This feature is currently in Dojo grids. This lazy loading enables loading of large datasets very fast and will be very desirable. I see some great potential in this grid.

I had a problem with loading jqGrid using json from a Microsoft wcf service. wcf wraps all data returned in a “d” tag/property. This is done as a simple countermeasure against certain types of forgery attacks. I simply added the following line to the addJSONData function of the grid.base.js file: if(data.d) data = data.d
Cheers!

No rows or columns are displayed when using an explicit width like – width: “400px” or width: “1600px”
I trying to get both horizontal and vertical scrolling to work within a div area.

Thanks!

expandSubgridRow seems to be expandSubGridRow in fact…

Hi,
i have a problem with “multi-requesting” to grid builder.
here is a code example:

$(“select#ms_makers”).change(function(){
buildElementsGrid($(this).val());
});

Hi,
i have a problem with “multi-requesting” to grid builder.
the grid is loading only once – can’t populate on new request
fom select changing…
may i have to do something like “$(‘#m_elms_tbl’).clear();”…
here is a code example:

$(“select#ms_makers”).change(function(){
var maker = $(this).val();
$(‘#m_elms_tbl’).jqGrid({
url:’request/series.php?nd=’+new Date().getTime()+’&maker=’+maker,
datatype: “json”……….
…
.
});

Hi,
i have a problem with calling javascript function on grid link.
Please reply.

@DizzyC
Waiting for your dragresizing code? Can you share your code, please?

can some one help me with javascript source code for insertion of data using jqgrid …… Thanks in advance..

Hi James:

Below is my code, I need to return the result as JSON, Please let me know how to do this.

Note: I am not using asp.net mvc

public string GetUsers(string sidx, string sord, int page, int rows)
{
int pageIndex = Convert.ToInt32(page) – 1;
int pageSize = 10;
int totalRecords = Context.Users.Count();
int totalPages = (int)Math.Ceiling((float)totalRecords / (float)pageSize);

var users = Context.Users.Skip(pageIndex * pageSize).Take(pageSize);

var jsonData = new
{
total = totalPages,
page = page,
records = totalRecords,
rows = (
from user in users
select new
{
i = user.Pk,
cell = new string[] { user.Pk.ToString(), user.FullName.ToString(), user.Email.ToString() }

}).ToArray()
};

return jsonData.ToString();

}

sample output : to fit in JQGrid.
{“page”:”1″,”total”:2,”records”:”13″,”rows”:[{“id”:”13″,”cell”:[“13″,”2007-10-06″,”Client 3″,”1000.00″,”0.00″,”1000.00”,null]},{“id”:”12″,”cell”:[“12″,”2007-10-06″,”Client 2″,”700.00″,”140.00″,”840.00”,null
]},{“id”:”11″,”cell”:[“11″,”2007-10-06″,”Client 1″,”600.00″,”120.00″,”720.00”,null]},{“id”:”10″,”cell”
:[“10″,”2007-10-06″,”Client 2″,”100.00″,”20.00″,”120.00”,null]},{“id”:”9″,”cell”:[“9″,”2007-10-06″,”Client
1″,”200.00″,”40.00″,”240.00”,null]},{“id”:”8″,”cell”:[“8″,”2007-10-06″,”Client 3″,”200.00″,”0.00″,”200
.00”,null]},{“id”:”7″,”cell”:[“7″,”2007-10-05″,”Client 2″,”120.00″,”12.00″,”134.00”,null]},{“id”:”6″
,”cell”:[“6″,”2007-10-05″,”Client 1″,”50.00″,”10.00″,”60.00”,null]},{“id”:”5″,”cell”:[“5″,”2007-10-05″
,”Client 3″,”100.00″,”0.00″,”100.00″,”no tax”]},{“id”:”4″,”cell”:[“4″,”2007-10-04″,”Client 3″,”150.00″
,”0.00″,”150.00″,”no tax”]}]}

I am stuck trying to switch themes. I have (exhaustively) toggled the grid.css style from various themes with little or no visible change in the grid. Also have reviewed the info related to themeroller but am missing something. There must be a function eg: “jQuery.(#mygrid”)jqGrid.setThemeBase(‘../scripts/jqGrid3.5/css/coffee’)” no?
Can someone provide a tip for me here please.

How to freeze column?

I have a cell that sometimes contains a lot of text including tags. Firefox expands vertically to show all the content, but IE clips the content. Has anyone else run into this problem and found a solution?

Hello ..
Just want to know how to clear the jqGrid? I tried to use the thegrid.clearGridData(); but it generates error.

Hi Team,
Can you also provide some demo work for using it with Oracle APEX.

Hi,
This is a great grid.
There are many many excellent features.
but one important feature is absent or not developed.
that is Freeze columns.
until then i cant use it in my application.

@Naidu
Hi Naidu,

Did you have any luck in finding a demo for APEX ? Please let me know if you find one. Thanks
Vamshi

Hi All
I am facing an issue while loading large dataset (around 6000 records). paging is enabled. But initial load is very slow and always ended up with slow script error of IE.

thanks in advance.

Hi can v freeze the last 2 columns of jqgrid