Start Building Professional
Web Apps Today


 
Categories Question details Back To List
Question  posted on Feb 22, 2007 10:44
open dhtmlx forum
I am trying your grid. It works fine, but now I want to save the modified data to database table through the ...

I am trying your grid. It works fine, but now I want to save the modified data to database table through the ‘SUBMIT' button of HTML. How do I do that?
Answer posted on Feb 22, 2007 10:45

Current version of dhtmlxGrid doesn’t have native form integration functionality.

To save data in DB you can use one of existing functionalities:

a) dhtmlxDataProcessor - which sync grid with DB by AJAX calls;

b) Serialize grid back to XML, send XML to server and process it on server manually.

Answer posted on Mar 13, 2008 06:17
Can u explain how this dataprocessor works in case of JSP and SQL server.
I contain the grid in a form, and when i click 'submit' button, the form data gets submitted. But how do I access the post data and update my DB
Answer posted by Support on Mar 13, 2008 07:27
There is two different way of sending data

a) dataProcessor - data sent not as part of form but as separate AJAX requests, server side script ( JSP in you case ) must process incoming response and send back results of operation
    if you need a JSP based sample of dataprocessor usage - please contact us directly at support@dhtmlx.com and provide your ref. number

b) FORM integration ( supported starting from dhtmlxgrid 1.4 ) - in such case data about updated cells and rows send as part of form submit, and need to be processed on server side as normal form.
Answer posted on Mar 14, 2008 05:12
is there any examples for dhtmlxgrid and form integration?
how do i retrieve the grid values after submitting the page?
Answer posted by Support on Mar 14, 2008 07:24
In case of using profession version of the grid,  this sample should be included in your package: dhtmlxGrid/samples/interaction_other_components/pro_form.html

Also you can see the sample on our site:

http://www.dhtmlx.com/docs/products/dhtmlxGrid/samples/interaction_other_components/pro_form.html

Answer posted by Alexandra (Support) on Dec 08, 2014 18:06

The information connected with php new mysqli and php ajax drag and drop also can help you, so please check it too.