Recording Editor's data changes

safavia

Good day pals,
I'm trying to build a gridview with the Editor as such that beside the source SQLServer table linked to Editor, the data change history also get recorded on a separate table in SQLServer.
Basically, I have the following SQLServer table called "Employees" populated on the Editor with inline editing capability:

I want anytime someone changes Employees table's data with the Editor, the changes history also get recorded on a separate SQLServer table called "EmployeesDataChangeHistory".

For example: User Jim Warner (who is the HR manager) on 1/1/2018 10:00, changes employee John Smith's title from "Engineer" to "Senior Engineer" and changes his salary from $100,000 to $120,000 using the Editor's inline editing function.

I want Employees table and EmployeesDataChangeHistory table in SQLServer get updated as below:

Thanks so much!

Cheers,
Alan

kthorngren

I would think the best approach would be to use your server script to update the change history table after it updates the employee table.

Kevin

kthorngren

This is a duplicate of this thread:
https://datatables.net/forums/discussion/51412/recording-editors-data-changes#latest

Kevin

safavia

Hi Kevin,
Thanks so much for the reply.

Alan