Why Adapter.Update(DataTable) causes AcceptChanges for whole DataSet?

#1

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.

#2

Forget it. I found it.
Relational Accept/RejectRule was settled to Cascade.

"Serg" <serg_nospam_ (AT) alef (DOT) ru> wrote

Quote:

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.

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Why Adapter.Update(DataTable) causes AcceptChanges for whole DataSet?

Dotnet Data Tools microsoft.public.dotnet.datatools

Why Adapter.Update(DataTable) causes AcceptChanges for whole DataSet? - 06-09-2006 , 02:54 AM

Re: Why Adapter.Update(DataTable) causes AcceptChanges for whole DataSet? - 06-09-2006 , 03:16 AM