I would like to apply audit trail function to connectors.
I want to capture table name, table field, old value and new value whenever
data is updated or inserted to SQL Server tables.
How could I capture data updated/inserted from connectors?
Should I make use of e.DataAction.Data?
I am using .NETversion.
Looking Forward to your reply asap.
Thanks a lot!!
yes, you may try using BeforeProcessing event:...
connector.BeforeProcessing += new EventHandler<DataActionProcessingEventArgs>(beforeProcessing);
void beforeProcessing(object sender, DataActionProcessingEventArgs e)
var id = e.DataAction.PrimaryKeyValue;
var type = e.DataAction.ActionType;
var newValues = e.DataAction.Data;
I think the only way is to manually retrieve item that’s being updated from the database and compare it’s fields with the new ones. All of this should be done on BeforeProcessing event, when the item is still unchanged
Get a guaranteed answer from DHTMLX technical support team
under the most suitable support plan