Updating 2 tables

S

Sebb77

Member
Joined
Feb 27, 2003
Messages
11
Location
Malta
Hi
Im trying to create an entry form based on two tables. I have a dataset with two datatable mapped to the database tables and i set a datarelation between these two.
Is it possible to update both datatables using a single dataadapter, or i have to create 2 different dataadapters so to set each insert/update/delete statement for each table?

Thanks for ur help.
 
Its possible to use the same dataadapter but Im using separate ones for what seems like clarity to me. Im interested to hear from others on this too.
 
well, as far as using the same data adapter is concerned to fill two different tables i dont fell it is possible.
i use different adapters too as it is more clear to code.

also one important thing is that suppose if you are using the command builder object to build the insert/update/delete commands for a table in the dataset it requires to have 2 different adapters.

however you can populate a single dataset with any number of tables but you must use individual dataadapters for filling the same dataset with each different table.
 
Back
Top