Dealing with DBConcurrencyException error in multi-table scenario

Hi

I am handling DBConcurrencyException for an adapter manager using code
below. My problem is how to merge table in error with its copy from
underlying database. If I need the table's data adapter for the merge, can I
extract the data adapter at run time from the information I have viz adapter
manager, dataset and the table in error.

Thanks

Regards


Try
Me.TableAdapterManager.UpdateAll(Me.MyDataSet)

Catch ex As DBConcurrencyException

For Each MyTable In MyDataSet.Tables
If MyTable.HasErrors Then

' How do I merge MyTable with the database copy of
itself here?

End If
Next

End Try