[javascript] Best dynamic JavaScript/JQuery Grid

I'm working with JavaScript, JQuery and HTML. UI Of my project is completely dynamic. I am looking for a dynamic JavaScript/JQuery Grid which supports following features.

Can anybody tell me is there any good looking open sources Grid which supports the following features?

1. I should be able to create an instance of the grid at run-time and add to DOM.
2. Supports column templates (textbox, select, checkbox or any inputs or simple text)
3. Supports set new column template or replace existing column template at real-time.
4. Few input control (e.g textbox, checkbox..) present under a column may be enabled and few may be disabled.
5. Supports setData() at real-time.
6. Supports event if any input data changed by user.
7. It should support selection of a Row
8. Add row or delete row support at real-time without rendering the whole grid.
9. Supports Paging.
10. Supports sorting by any column at real-time.
11. Fires an event if data is sorted by user at real-time.
12. Grid UI must support realizable columns
13. Auto re-sizable (It will be great if grid is auto re-sizable according to the size of the parent element)
14. Definitely has good documentation.

My suggestion for dynamic JQuery Grid are below.

http://reconstrukt.com/ingrid/

https://github.com/mleibman/SlickGrid

http://www.datatables.net/index

Best one is :

DataTables is a plug-in for the jQuery Javascript library. It is a highly flexible tool, based upon the foundations of progressive enhancement, which will add advanced interaction controls to any HTML table.

Variable length pagination

On-the-fly filtering

Multi-column sorting with data type detection

Smart handling of column widths

Display data from almost any data source

DOM, Javascript array, Ajax file and server-side processing (PHP, C#, Perl, Ruby, AIR, Gears etc)

Scrolling options for table viewport

Fully internationalisable

jQuery UI ThemeRoller support

Rock solid - backed by a suite of 2600+ unit tests

Wide variety of plug-ins inc. TableTools, FixedColumns, KeyTable and more

Dynamic creation of tables

Ajax auto loading of data

Custom DOM positioning

Single column filtering

Alternative pagination types

Non-destructive DOM interaction

Sorting column(s) highlighting

Advanced data source options

Extensive plug-in support

Sorting, type detection, API functions, pagination and filtering

Fully themeable by CSS

Solid documentation

110+ pre-built examples

Full support for Adobe AIR

Have a look at agiletoolkit.org as this has a simple to use CRUD which supports 2,4,6,7,9,10 and 12 out of the box (uses Ajax to defender the grid when adding,deleting data and it integrates with jquery.

I would post some examples but on an iPad at the moment.

Some useful are:

Free:

• Gijgo Grid
• Backgrid.js
• Flexigrid
• jqGridView
• Ingrid
• SlickGrid
• DataTables
• Shield UI Lite Grid

Paid:

• Fancy Grid
• jQuery Grid
• jqxGrid
• Shield UI Grid

The best entries in my opinion are Flexigrid and jQuery Grid.

you can try http://datatables.net/

DataTables is a plug-in for the jQuery Javascript library. It is a highly flexible tool, based upon the foundations of progressive enhancement, which will add advanced interaction controls to any HTML table. Key features:

• Variable length pagination
• On-the-fly filtering
• Multi-column sorting with data type detection
• Smart handling of column widths
• Display data from almost any data source
• DOM, Javascript array, Ajax file and server-side processing (PHP, C#, Perl, Ruby, AIR, Gears etc)
• Scrolling options for table viewport
• Fully internationalisable
• jQuery UI ThemeRoller support
• Rock solid - backed by a suite of 2600+ unit tests
• Wide variety of plug-ins inc. TableTools, FixedColumns, KeyTable and more
• It's free!
• State saving
• Hidden columns
• Dynamic creation of tables
• Ajax auto loading of data
• Custom DOM positioning
• Single column filtering
• Alternative pagination types
• Non-destructive DOM interaction
• Sorting column(s) highlighting
• Advanced data source options
• Extensive plug-in support
• Sorting, type detection, API functions, pagination and filtering
• Fully themeable by CSS
• Solid documentation
• 110+ pre-built examples
• Full support for Adobe AIR