I have a dataset consisting of 3 datatables
There is one parent table, and 2 child tables
I have set up foreign key constraints (with UpdateRule = Rule.Cascade) on
the primary key, etc
The user populates the parent table with a new record, then populates the
child tables, and finally hits update
At this point, I want to save the dataset to the database (SQL Server)
I've create the SPs, etc, and they work fine, but I'm having problems
updating the child tables
I use a SQLDataAdapter to update the parent table, and the PK field is
updated from the database
This in turn updates the appropriate field in the child datatables via the
foreignKeyContraints
The problem, is that at this point, the child tables seem to be updated (ie
GetChanges returns Nothing, and no update gets done when I pass it to it's
DataAdapter)
GetChanges *does* however return the changes before calling update on the
parent table, so I'm thinking that it's expecting me to update all three
tables in one shot.
I'd supply code, but the above pretty well sums up the situation (and the
code is a little long winded)
I've been on this for a few hours now, and the help samples either
update the parent table
add the records to the child DataTable
then update the child table
or
the entire dataset is passed to the InsertCommand of the parent
table via GetXML
I can't do the former, as the dataset is being populated first
and I can't do the latter as the dataset *could* be quite large (resulting
in indeterminately sized (and potentially large) XML strings being passed to
the SP)
Hoping someone can help :-)
Merak
You can read messages from the DOTNET archive, unsubscribe from DOTNET, or
subscribe to other DevelopMentor lists at http://discuss.develop.com.
