Advertisement
Guest User

Untitled

a guest
Jul 28th, 2017
55
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.83 KB | None | 0 0
  1. For i As Integer = 0 To beforeEdit.Columns.Count - 1
  2. If beforeEdit(0).Item(i) <> afterEdit(0).Item(i) Then
  3. 'storing log which column have changed
  4. End If
  5. Next
  6.  
  7. Private Sub LogRecordChanges(row As DataRow)
  8. If row.RowState = DataRowState.Unchanged Then
  9. Console.WriteLine("No changes to row.")
  10. Else
  11. For Each column As DataColumn In row.Table.Columns
  12. Dim currentValue = row(column, DataRowVersion.Current)
  13. Dim originalValue = row(column, DataRowVersion.Original)
  14.  
  15. If currentValue.Equals(originalValue) Then
  16. Console.WriteLine($"No changes to column '{column.ColumnName}'.")
  17. Else
  18. Console.WriteLine($"Column '{column.ColumnName}' changed from '{originalValue}' to '{currentValue}'.")
  19. End If
  20. Next
  21. End If
  22. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement