Basically I have one task I need to complete successfully before another one
is attempted.
I update one record in one table with information. I then need to insert or
update multiple rows into another table based on the items selected in a
listbox with multiple selection enabled.
Here is a good example:
User information with 5 fields in table A.
Update any fields that changed.
Table b is the groups user is a member of. The admin can select or remove
any groups the user is a member of. In table b there is a row for each group
the user is a member of.
UserID GroupID
I will need to enumerate the items in an arraylist and based on the item
value update or insert into table b. However, this can only occur if the
table A update completed successfully.
Any ideas.
Thanks