Only send updated values on batch save

[Roland Vaandrager]

Hello,

I created a grid with many columns, one for each year. The grid uses batch mode, to be able to edit cells one at a time.

I have two questions:

1. Each time I click "Save", the complete row is sent to the server via the dataSource object. In this case, only some cells are updated in one go, instead of the complete row. Is it possible to send only changed values? In the attached example, I changed a value for column "year_2018" only. Now, the contents of sent-to-server.json are sent. It would really help me if only the value of year_2018 are sent to the server, as shown in only-changed-to-server.json.
   

2. I would like to automatically save each changed cell after an edit, without having to explicitly click "Save".

Thank you for your support!

Attachment: syncfusiongridexample_1a035c73.zip

[Sujith Kumar Rajkumar]

Hi Roland, 

 

Greetings from Syncfusion support. 

 

Please find the response for your queries below, 

 

Query – 1: “Each time I click "Save", the complete row is sent to the server via the dataSource object. In this case, only some cells are updated in one go, instead of the complete row. Is it possible to send only changed values?” 

 

Based on this query we would like to let you know that with batch editing, we can perform cell edit on individual cells but on save the entire row data will only be sent to the server(when remote data is used) which is the default behavior of Grid’s batch editing functionality. The individual cell values cannot be sent on save because when changing a cell value the entire row data will be pushed as the batch changes which will be sent on performing save action. This is the behavior of this functionality based on the Grid’s current architecture. 

 

Query – 2: “I would like to automatically save each changed cell after an edit, without having to explicitly click "Save".” 

 

The Grid’s batch editing functionality allows to perform multiple CRUD actions like add, edit, delete on the Grid rows and on performing each action the changes will be pushed into a batch changes variable within the source. Because of this the save action will not be called after performing each edit as user can perform multiple CRUD actions and save the changes as a whole. So when each change occurs it will only be updated in a virtual storage and not affect the Grid’s data source. Only when the save action is performed these changes are updated to the Grid’s data source. This is the default behavior of the batch edit functionality of the Grid. 

 

Please get back to us if you require any further assistance. 

 

Regards, 

Sujith R