I would update the dataset and then update the DB using the .update on the adapter passing it the dataset. You may also want to look into .getchanges of the dataset.
-----Original Message----- From: Bob Edwards [mailto:[EMAIL PROTECTED]] Sent: Monday, April 15, 2002 2:40 PM To: [EMAIL PROTECTED] Subject: [DOTNET] updating dataset and dataform I have a design in which I fill a dataset with two tables and I create a relation between them. The queries to fill the two tables use lookups into other tables (e.g., the main table holds an integer which is an id in a lookup table). I use that dataset to fill a datagrid in a form. Works great. When you click on a row in the grid, you see a detail page in a panel below the grid. You can edit the record in the panel and click SAVE. When you do, a new record is created in the secondary table. My question is this: I want save to update the database and I want the grid and the panel to be updated as well. Would you a) update the db and then recreate the dataset and refresh the grid or b) update the dataset and then use that to update the database Which is the preferred approach, and why? Thanks. Bob Edwards. You can read messages from the DOTNET archive, unsubscribe from DOTNET, or subscribe to other DevelopMentor lists at http://discuss.develop.com. You can read messages from the DOTNET archive, unsubscribe from DOTNET, or subscribe to other DevelopMentor lists at http://discuss.develop.com.
