Background:
I have two forms: Form1 displays some summary information and Form2 allows
you to edit the details. I have one dataset(dsMain) that both forms use.
The dataset is actually on the summary form and the edit form references that
dataset such as:
'On Summary form
Dim frm as New Form2
frm.Main = Me
frm.ShowDialog(me)
'On Edit Form
Public Main as Object
Dim ds as DateSet
'On Edit Form Load Event
ds = Ctype(Main, Form1).dsMain
That way Form2 has access to the same data in Form1. Anyway, I run into a
problem when I try to update two tables from dsMain. When submitting Form2,
it performs Transactional updates using SQLDataAdapters. Stepping through
the code, the first SQLDataAdapter updates the first table, but the second
SQLDataAdapter seems to lock up and does not ever complete. Also, on the
second datatable update, I find a specific datarow and update it using
dr.BeginEdit, dr.Field1 = "Whatever", dr.EndEdit. When the code gets to
dr.EndEdit, it takes about a minute for it to complete and then trys to
execute the SQLDataAdapter.Update(datatable), but that is the point where it
seems to lock up. It also locks up at the second update even if I use a
command or stored procedure for the first update. I was thinking it had
something to do with the Transaction.
If you just update one of the tables, it runs fine. Any ideas why it might
be locking up trying to update more than one datatable? I do it on other
forms without any problems. I've been struggling with this all day. Any
help is greatly appreciated.