I am a newbie with dataset. May be I do somthing wrong with dataset? I have a dataset with many tables (about 50 tables). All tables are linked with foreign key references. User inserts new rows in DataTables. When I do update to db I think I should update tables in order they are linked. But when I call Adapter.Update(MyMainDataTable) it causes in linked tables all rows with a RowState Added become Unchanged. I don`t understand why this happens. How can I update my linked tables? May be I am not aware of some simple things? Please help. Thanks in adv. Serg.
Forget it. I found it. Relational Accept/RejectRule was settled to Cascade. "Serg" wrote in message news:%23bJygn5iGHA.3588@TK2MSFTNGP02.phx.gbl... >I am a newbie with dataset. May be I do somthing wrong with dataset? > I have a dataset with many tables (about 50 tables). All tables are linked > with foreign key references. > User inserts new rows in DataTables. When I do update to db I think I > should update tables in order they are linked. But when I call > Adapter.Update(MyMainDataTable) it causes in linked tables all rows with a > RowState Added become Unchanged. > I don`t understand why this happens. How can I update my linked tables? > May be I am not aware of some simple things? > Please help. > Thanks in adv. > Serg. >
