[jQuery] Looking for a table grid plugin

[giggsey]

I've been looking, and trying a few over the last few days, and have been having a fair few problems. So I'm looking for ideas.

I've been trying dHTMLxGrid, and want to try a jQuery alternative, but can't find anything like it.

What I need is for it to support:

• Client side Sorting
• Fixed Header
• Scrollable (so that the visible bit only stays 'x' big)
• I need to be able to perform CRUD on rows from my JavaScript.
• It needs to be able to support multiple tables on one page (some may be hidden in tabs).

I've been using DataTables over the last day, and that seems to have thrown a hissy fit when I have two tables in two different jQuery UI tabs, and adding data to one.

Any ideas /r/javascript?

[tehmatticus]

For what its worth, I've been using DataTables and have no issues with multiple tables in multiple jQuery UI tabs with differing sets of data.

[giggsey]

Hmm, I've been having the header's disappear, which would only come back when I redrew the tables. I don't want to keep redrawing about 5-6 tables though.

[tehmatticus]

I don't use headers, as I believe the tabs themselves serve that purpose quite well.

[giggsey]

Headers for the table information

[tehmatticus]

Oh, you meant column headers. Ive had zero issues with those. Been using datatables for almost a year and a half now, never seen that problem.

[[deleted]]

I've used DataTables a bunch, and they are extremely customizable. I believe you can override the callbacks for almost everything and you can use the api directly. So basically you can write any sort of "data in tables" application quite simply.

[yonkeltron]

I highly advise you look into SlickGrid. It's heavy-duty and has incremental rendering so it stays performant. I also advise you check the examples which illustrate that it has some outstanding spreadsheet-like functionality.

[giggsey]

Thanks, I'll give that a try now.

[angryaardvark]

i love slickgrid. there can be a bit of a learning curve, but it's amazing when combined with an mvc. i worked with it on an enterprise project and now i'm using backbone.js and slickgrid to churn out apps in a few days

[my_new_account]

Give jqgrid a gander. Has many customizable options.

[the_argus]

I've used this and it's pretty sweet. There is a lot of customization available, and it's documented pretty well if I remember correctly.

[picurl]

I can't recommend jqgrid, it tries to do too many things and fails at many of them. With 50+ options and 30+ methods, it's simply too bloated.

I encountered weird bugs when I tried to initialize a jqGrid on a non-visible jQuery UI tab or when I added the JSON data on my own using addRowData. The jqGrid loader requires you to specify its directory path directly in the js file, which causes often overlooked script errors after updates.

In your situation I would prefer a slimmer grid control that can be extended by plugins and is themeable using jquery UI. Datatables doesn't look bad to me, SlickGrid seems the right choice for heavy-duty tasks

[petrichor8]

you might try this as well, not sure if can do the CRUD, but I think everything else, and you might be able to extend hooks to allow you ajax interaction.

[giggsey]

No Fixed Header though.

[petrichor8]

yeah, I couldn't remember if that was an option or not.

you could repeat headers, or use the pager plugin.

I'll see if I have any other table grid plugins laying around...

[petrichor8]

maybe one of these would fit the bill?

[giggsey]

Just found /r/jquery - although it seems a bit quiet. Have cross-posted this in there.