Datagridview - Writing Journal Transactions for a Datagridview

[Bob Roggy]

I would like to write transaction activity to a journal table, specifying
Add, Update, or Delete and some information regarding each transaction when a
user works in a datagridview.

I have tried:

Dim deletedChildRec ords As dsVersaPress.Ro utingDataTable = _

CType(DsVersaPr ess.Routing.Get Changes(Data.Da taRowState.Dele ted),
dsVersaPress.Ro utingDataTable)

Dim newChildRecords As dsVersaPress.Ro utingDataTable = _
CType(DsVersaPr ess.Routing.Get Changes(Data.Da taRowState.Adde d),
dsVersaPress.Ro utingDataTable)

Dim modifiedChildRe cords As dsVersaPress.Ro utingDataTable = _

CType(DsVersaPr ess.Routing.Get Changes(Data.Da taRowState.Modi fied),
dsVersaPress.Ro utingDataTable)

Try
If deletedChildRec ords IsNot Nothing Then
Dim hCount As Integer
Dim hOperation As String
Dim hOperDesc As String
Dim hDeleteRecCount As Integer = deletedChildRec ords.Count
For hCount = 0 To hDeleteRecCount - 1
hItemNo = deletedChildRec ords.Rows(hCoun t)("Operation" )
hOperation = deletedChildRec ords.Rows(hCoun t)("Operation" )
hOperDesc = deletedChildRec ords.Rows(hCoun t)("OperDesc")
Next

RoutingTableAda pter.Update(del etedChildRecord s)

End If

If newChildRecords IsNot Nothing Then

Dim hNewRecCount As Integer = newChildRecords .Count
RoutingTableAda pter.Update(new ChildRecords)

End If

If modifiedChildRe cords IsNot Nothing Then

Dim hModifiedRecCou nt As Integer = modifiedChildRe cords.Count
RoutingTableAda pter.Update(mod ifiedChildRecor ds)
End If

DsVersaPress.Ro uting.AcceptCha nges()

Catch ex As Exception
MessageBox.Show ("An error occurred during the update process")

' Add code to handle error here.

Finally
If deletedChildRec ords IsNot Nothing Then
deletedChildRec ords.Dispose()
End If

If newChildRecords IsNot Nothing Then
newChildRecords .Dispose()
End If

If modifiedChildRe cords IsNot Nothing Then
modifiedChildRe cords.Dispose()
End If

End Try

This isolates the Insert, Delete, and Update tranactions ; but I can not
access deletedChildRec ords rows and individual fields. Is there a way to do
this?