Looking for a good datagrid plug-in for jQuery

Question

I have a requirement to let my users maintain some accounts and accommodations. Each account can 1 to many accommodations and each accommodation is link to only 1 account.

I want to be able to let the users edit the account details. On the same page I would like to list the accommodations that are linked to that account and allow the user to link more accommodations to that account, double click on an accommodation to edit its details and to also be able to delink the accommodation.

I thought that is really suited to having a datagrid for the accommodations as well as maybe a lookup field to add more accommodations to the datagrid. Can anyone recommend a jQuery datagrid?

EDIT: Been looking around and found the following.

• jqGrid
• FlexiGrid
• ingrid

so far my favourite looks like jqGrid

Answer 1

Flexigrid is the best one. Highly recommend.

Here is the -> SAMPLE

Another alternative is jqGrid. And here is the -> DEMO. There are more interesting features. But it looks ugly in my opinion.

Answer 2

I'm using jqGrid now. I like it more than Flexigrid for the following reasons:

• Supports trees, sub-grids, and other drill down features
• Many options for in-row and pop-up form editing.
• Several themes to choose from, with support for jQuery UI themes coming RSN.
• There is actual documentation
• It has been very easy for me to customize to do things that neither grid does "out-of-the-box"

Update: I wrote a short article on its advantages and disadvantages in more detail, but with an ASP.NET MVC focus.