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.
