We are planning to use DHTML Grid on a project, and would like to know,
1. How is the data stored in DHTML grid, XML or SQLite
2. How do we perform CRUD operations on the grid?
- How is the data stored in DHTML grid, XML or SQLite
Grid uses inner data model, XML can be used as datasource, but it will not be preserved
Because component is fully client side it can’t use any SQL-like datasources ( but it can connect to them by server side scripts )
>>2. How do we perform CRUD operations on the grid?
Grid have rich API to add|delete|update rows|cells in grid.
The data changes in grid can be synced with server side storage by next methods
a) By using dataProcessor library, in such case for each action in grid ( adding/deleting/editing) related event handler generate AJAX call to server side. You only need to implement the correct DB updates for specified AJAX calls.
dhtmlx.com/docs/products/dhtmlxG … 5235006000
b) By serialization. The dhtmlxGrid can be serialized back to XML and sent to server ( the sending routine is not implemented in grid and must be implemented manually ), where XML can be parsed, data extracted and DB updated.
c) form integration - grid can integrates in surrounding tag and include all ( changed ) values in form scope on submit.
d) handle onCellChanged or onCellEdit events and make custom sync on cell value changing