question on DataRow versioning w/r to DBConcurrencyException

B

boo

hi all -

in concurrency exception handling, i am trying to use the
DBConcurrencyException's .Row property to provide me with the 'original' and
'proposed' versions of the data.

if i access the data by column, i can access the multiple versions of the
data like so:

\\\
Private Function ResolveConcurrencyViolation(ByVal dbcx As
DBConcurrencyException) As Boolean
'irrelevant code omitted.
strOriginal &= dbcx.Row(i, DataRowVersion.Original)
strProposed &= dbcx.Row(i, DataRowVersion.Current)
End Function
///

but strings proved inadequate for presenting the various versions of the
data back to the user, so i want to do a custom dialog with 3 DataGrids -
one each for "original", "other user's changes", and "proposed changes"

to do so, i want to pass 3 datasets, each containing the appropriate
row/version

but i can't figure out how to access the Original/Current version for the
row as a whole.

i want to do something like this:

\\\
Dim dsOrig as Dataset, dsProposed as DataSet
dsOrig.Tables(0).ImportRow(dbcx.Row(DataRowVersion.Original))
dsProposed.Tables(0).ImportRow(dbcx.Row(DataRowVersion.Current))
///

but this is invalid syntax, as those of you laughing already know! ;-)

i have looked around the object overview for a DataRow and i can't seem to
find the property/method/syntax i'm looking for.

can anyone provide any insight?!

it would be most appreciated! THANKS!!! =)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top