Kendo Grid – Batch Incell – Save changes with single trigger for create/update/destroy

[Fusionex Corp Sdn Bhd]

Currently I am using Kendo Grid in MVC 4 razor, with Batch InCell mode.

Let say my grid got 10 records, I added 2 records, updated 3records, and deleted 1 record.

If I am using kendo default command save changes function, it will trigger controller for 3 times (create function(2 records), update
function(3 records), destroy function(1 record))

Currently our problem is that we don’t know how to handle
SQL Transaction if it is triggered differently.

Can it be triggered once with all the changes records / or all records (including deleted record)? 

Or can I create a button out of the grid with function to post the grid datasource to controller (this datasource should include deleted record with flag “delete”, updated record with flag “updated”)?

Or is there any other method that I can achieve this?

Thanks

[Vladimir Iliev]

Hi Gan,

 
Basically sending all updated / deleted / new records with one request to the server is not supported out-of-the-box and it will require custom solution, which is out of scope of our support service as it covers the build-in functionality of the controls only.

For convenience I created small example which demonstrates such custom solution and attached it to the current thread (the project is self-explanatory).

Kind Regards,
Vladimir Iliev
Telerik