jqGrid with dynamic colModel?

Question

I have to create a data table simmiliar to the http://www.chartle.net/ have.

The most importang feature is :

1. Row can be added/remove dynamically (done)
2. Column can be added/remove dynamically (how can i do this ?)
3. The changed colModel can be saved in database for feature modification ..

Is this possible ?

Answer 1

Search getColProp and setColProp in their docs: http://www.trirand.com/jqgridwiki/doku.php?id=wiki:methods

Answer 2

The problem is, that you can't dynamically change the jQgrid ColModel. The two options I see are:

1. Delete the whole grid and reload it with a new ColModel (if it can change entirely) using GridUnload:

   jQuery(selector).GridUnload(selector);

2. Load all possible rows and show/hide the ones you need, e.g. by using the show hide columns plugin

For saving it dynamically it should be sufficient to store the configuration data for the grid in the database as JSON.