Parent <-> Child Updates

17 Feb 2006 5:29 PM

Radi Radichev

Hi!
I'm having trouble updating a dataset. So this ist my situation: I insert a
new data source in my application and it is a table from Access mdb
database. This table is related to another table in the database that i do
not include in my new dataset. When i update the dataset with:
this.Validate();

this.trucksBindingSource.EndEdit();

this.trucksTableAdapter.Update(this.trucksDataSet.trucks);

this.trucksDataSet.AcceptChanges();

It tells me that it can't update the table because it is related to another
table in the database... Can anyone help me ? How do I fix this? Thanks!

Greets!

19 Feb 2006 2:27 PM

pvdg42

Show quote

"Radi Radichev" <radi.radic***@uni-jena.de> wrote in message
news:%23Xm0Gf%23MGHA.740@TK2MSFTNGP12.phx.gbl...
> Hi!
> I'm having trouble updating a dataset. So this ist my situation: I insert
> a new data source in my application and it is a table from Access mdb
> database. This table is related to another table in the database that i do
> not include in my new dataset. When i update the dataset with:
> this.Validate();
>
> this.trucksBindingSource.EndEdit();
>
>
> this.trucksTableAdapter.Update(this.trucksDataSet.trucks);
>
> this.trucksDataSet.AcceptChanges();
>
> It tells me that it can't update the table because it is related to
> another table in the database... Can anyone help me ? How do I fix this?
> Thanks!
>
>
>
> Greets!
>
>

Can you be more specific on what type(s) of updates you are attempting?
Inserts, deletes?
Is the table you are updating the "one" side or the "many" side of the
relationship?
Can you quote the exact text of the error message?