C
Cor Ligthert
Hi Mad,
I go just for this simple one.
Me.BindingContext(dsCentrexLines).EndCurrentEdit()
If dsCentrexLines.haschanges Then
Try
Me.odcPhones.Open()
Me.odaSites.Update(dsCentrexLines, "rigthtable")
'rightable=Sites?
Me.odaDepartments.Update(dsCentrexLines, "rigthtable")
Me.odaPrimaryUser.Update(dsCentrexLines, "rigthtable")
Me.odaCommsType.Update(dsCentrexLines, "rigthtable")
Me.odaCentrexLines.Update(dsCentrexLines, "rigthtable")
End If
Catch updateException As System.Exception
Throw updateException
Finally
Me.odcPhones.Close()
End Try
End if
' And if there are no error or/an you have resolved them than the Fill's
again to do an update from your dataset when other users has added new
lines.
The dataadapter update does with a full dataset a lot of things for you.
I hope you succeed in the weekend
Cor
I go just for this simple one.
Me.BindingContext(dsCentrexLines).EndCurrentEdit()
If dsCentrexLines.haschanges Then
Try
Me.odcPhones.Open()
Me.odaSites.Update(dsCentrexLines, "rigthtable")
'rightable=Sites?
Me.odaDepartments.Update(dsCentrexLines, "rigthtable")
Me.odaPrimaryUser.Update(dsCentrexLines, "rigthtable")
Me.odaCommsType.Update(dsCentrexLines, "rigthtable")
Me.odaCentrexLines.Update(dsCentrexLines, "rigthtable")
End If
Catch updateException As System.Exception
Throw updateException
Finally
Me.odcPhones.Close()
End Try
End if
' And if there are no error or/an you have resolved them than the Fill's
again to do an update from your dataset when other users has added new
lines.
The dataadapter update does with a full dataset a lot of things for you.
I hope you succeed in the weekend
Cor