Audit trail in gridgroupingcontrol

[Nicolas]

Hi, I am trying to make an audit trail in a GGC where I can gather Column name, Row ID, the Table name, Current user and Old value + New value of the field that has been changed. For the Table name, current user, I have no problem to retrieve a global variable, now as for gathering the other values, and in particular the Old and new value, it is a bit more challenging than I thought... I tried the following with no success, any help in providing direction for the event and procedure to use to get this would be welcomed!  - Nicolas

Private Sub GridGroupingControl1_CurrentRecordContextChange(sender As Object, e As CurrentRecordContextChangeEventArgs) Handles GridGroupingControl1.CurrentRecordContextChange

If (e.Action = Syncfusion.Grouping.CurrentRecordAction.BeginEditComplete) Then

Dim varOld As VariantType

Dim varNew As VariantType

Dim i As Integer

Dim record As Record = Me.GridGroupingControl1.Table.CurrentRecord

   For i = 0 To record.GetCustomCount

   varOld = record.GetOldValue(i)

   varNew = record.GetValue(i)

   Next i

End If

end sub

[Nicolas]

Found it!

Private Sub GridGroupingControl1_RecordValueChanging(sender As Object, e As RecordValueChangingEventArgs) Handles GridGroupingControl1.RecordValueChanging

Dim NewValue As VariantType = e.NewValue.ToString

Dim ColumnName As String = e.Column

Dim Oldvalue As VariantType = e.Record.GetValue(ColumnName).ToString

Dim TableName As String = GlobalVariables.CurrentTable

Dim CurUser As String = GlobalVariables.CurrentUserAbbrev

　

End Sub

[Piruthiviraj Malaimelraj]

Hi Nicolas, 

 

Thank you for using Syncfusion products. 

 

We are glad to hear from you that you have found the solution. Please let us know if you have any other queries. 

 

Regards, 

Piruthiviraj