DataAdapter.Update Fails on child table

[Tom Petrelli]

I have a GGC with parent/child relationship. The DataAdapter.Update for the parent works fine, but the Child does not update, it always returns 0 for the update count.
Thx.

[Administrator]

Hi

this.sqlDataAdapter1.Fill(dataSet11,"Parent");
this.sqlDataAdapter2.Fill(dataSet11,"Child");

The above code is used to fill the dataset using the Parent and Child tables.

this.sqlDataAdapter1.Update(dataSet11);
this.sqlDataAdapter2.Update(dataSet11);

These codes are used to update the parent and child tables respectively.

I guess that you might have missed to update the child table using its own DataAdapter as I mentioned above.

Please send me a sample with the issue if this doesn''t serve your purpose.

Best Regards
Mouli.