How are you populating the detail form? Another query w/ additional fields returned, copying the values from the list dataset, or databinding the detail form to the list dataset? These are all valid approaches, but binding to the same dataset probably requires the least coding, and is the approach most people take.
-Ethan -----Original Message----- From: dotnet discussion [mailto:[EMAIL PROTECTED]] On Behalf Of Bob Edwards Sent: Monday, April 15, 2002 8:08 PM To: [EMAIL PROTECTED] Subject: Re: [DOTNET] updating dataset and dataform Yes, except that the user is not updating through the grid. The user is interacting through a form that represents the data that is in the grid. Imagine you have orders/details. The grid shows an order, and you can click the plus sign to see the details. In my program, when you click on an order, a form opens with all the details together. You can then change anything through the form, and both the order and the detail will be updated. That update is not in the dataset (should it be somehow?) and thus the update must be applied both to the dataset and to the back end database. Thanks again. -j > -----Original Message----- > From: dotnet discussion [mailto:[EMAIL PROTECTED]]On Behalf Of > Shawn Wildermuth > Sent: Monday, April 15, 2002 7:31 PM > To: [EMAIL PROTECTED] > Subject: Re: [DOTNET] updating dataset and dataform > > > If your updates are not entirely in the DataSet, then the approach to > update the database first is fine. The question I have is why doesn't > it exist in the DataSet. Wouldn't it make more sense to cache all the > data in a DataSet, create a DataView to get the view of the data to bind > the grid to. And finally update the database on every change to the > DataSet alone? > > Thanks, > > Shawn Wildermuth > [EMAIL PROTECTED] > > > -----Original Message----- > > From: dotnet discussion [mailto:[EMAIL PROTECTED]] > > On Behalf Of Bob Edwards > > Sent: Monday, April 15, 2002 6:49 PM > > To: [EMAIL PROTECTED] > > Subject: Re: [DOTNET] updating dataset and dataform > > > > > > Shawn, > > > > You are very patient, but we're not quite there yet. > > > > > Why don't you make the changes directly to the DataSet instead of > > > refreshing it from the Database every time? > > > > Right, that is my question. Is there a reason it is better to > > update the dataset rather than refreshing the db? We want to > > save each update to the DB (so it won't be lost). Is there a > > reason to go from the pane to the dataset to the DB rather > > than from the pane to the DB to the dataset? > > > > Thanks. > > > > -j > > > > > -----Original Message----- > > > From: dotnet discussion > > [mailto:[EMAIL PROTECTED]]On Behalf > > > Of Shawn Wildermuth > > > Sent: Monday, April 15, 2002 5:49 PM > > > To: [EMAIL PROTECTED] > > > Subject: Re: [DOTNET] updating dataset and dataform > > > > > > > > > Why don't you make the changes directly to the DataSet instead of > > > refreshing it from the Database every time? Otherwise, I'd > > update the > > > database first, and refresh everything in the order you did > > when the > > > page started. > > > > > > Thanks, > > > > > > Shawn Wildermuth > > > [EMAIL PROTECTED] > > > > > > > -----Original Message----- > > > > From: dotnet discussion [mailto:[EMAIL PROTECTED]] > > > > On Behalf Of Bob Edwards > > > > Sent: Monday, April 15, 2002 5:37 PM > > > > To: [EMAIL PROTECTED] > > > > Subject: Re: [DOTNET] updating dataset and dataform > > > > > > > > > > > > Okay, now I'm confused. Here's what I have: > > > > 1. I load the dataset from the db > > > > 2. I display the datagrid > > > > 3. User clicks on a record and I show details in a panel based on > > > > the record selected 4. User updates the panel and clicks a save > > > > button 5. I want the datagrid and the panel to be updated > > with the > > > > new changes. These have to be written back to the db. The dataset > > > > also has to be updated; there is no direct change made to the > > > > dataset based on changes the user makes to the panel > > > > > > > > Am I missing something? > > > > > > > > Thanks. > > > > > > > > Bob > > > > > > > > > -----Original Message----- > > > > > From: dotnet discussion > > > > [mailto:[EMAIL PROTECTED]]On Behalf > > > > > Of Shawn Wildermuth > > > > > Sent: Monday, April 15, 2002 5:20 PM > > > > > To: [EMAIL PROTECTED] > > > > > Subject: Re: [DOTNET] updating dataset and dataform > > > > > > > > > > > > > > > No problem. > > > > > > > > > > I guess I still don't quite get why you are updating the > > > > database then > > > > > requering it. Are you trying to sync up all the updates > > > > that everyone > > > > > has done? If not, your DataSet should already be what > > is in the > > > > > database. > > > > > > > > > > Thanks, > > > > > > > > > > Shawn Wildermuth > > > > > [EMAIL PROTECTED] > > > > > > > > > > > -----Original Message----- > > > > > > From: dotnet discussion [mailto:[EMAIL PROTECTED]] > > > > > > On Behalf Of Bob Edwards > > > > > > Sent: Monday, April 15, 2002 5:10 PM > > > > > > To: [EMAIL PROTECTED] > > > > > > Subject: Re: [DOTNET] updating dataset and dataform > > > > > > > > > > > > > > > > > > Shawn, > > > > > > > > > > > > First, thank you for taking so much time to answer my > > questions. > > > > > > Next, and I don't mean to challenge your answer at > > all, but I'm > > > > > > trying to understand it, can you say why #2 is better? I > > > > have code > > > > > > that updates the db through a stored procedure. I then > > > > can requery > > > > > > for the dataset and then assign the dataview to the datagrid. > > > > > > > > > > > > Would it be cleaner or more efficient to update the > > dataset, and > > > > > > then have the dataset update the database? I'm willing, > > > > I'd like to > > > > > > get it right, but I want to understand why one is better than > > > > > > the other. > > > > > > > > > > > > Thanks again > > > > > > > > > > > > Bob. > > > > > > > > > > > > > -----Original Message----- > > > > > > > From: dotnet discussion > > > > > > [mailto:[EMAIL PROTECTED]]On Behalf > > > > > > > Of Shawn Wildermuth > > > > > > > Sent: Monday, April 15, 2002 4:47 PM > > > > > > > To: [EMAIL PROTECTED] > > > > > > > Subject: Re: [DOTNET] updating dataset and dataform > > > > > > > > > > > > > > > > > > > > > Hmmm.... > > > > > > > > > > > > > > I think #2 makes more sense. If were my system, I would > > > > > > wrap the fact > > > > > > > that you are updating multiple tables from a single > > row in a > > > > > > > stored procedure. In that way, creating the > > > > DataAdapter's Command > > > > > > > objects will be trivial (ok, Stored Procs are never > > trivial). > > > > > > > That way you can update the database from the > > DataSet and you > > > > > > > should > > > > > > never have to > > > > > > > rebind to the DataGrid. Am I still missing the point? > > > > > > > > > > > > > > Thanks, > > > > > > > > > > > > > > Shawn Wildermuth > > > > > > > [EMAIL PROTECTED] > > > > > > > > > > > > > > > -----Original Message----- > > > > > > > > From: dotnet discussion > > [mailto:[EMAIL PROTECTED]] > > > > > > > > On Behalf Of Bob Edwards > > > > > > > > Sent: Monday, April 15, 2002 4:12 PM > > > > > > > > To: [EMAIL PROTECTED] > > > > > > > > Subject: Re: [DOTNET] updating dataset and dataform > > > > > > > > > > > > > > > > > > > > > > > > Thanks for the feedback but my question must not > > have been > > > > > > > > clear. > > > > > > > > > > > > > > > > I can update in one of two ways: > > > > > > > > > > > > > > > > 1. Update the database and then refill the dataset and > > > > > > then rebind > > > > > > > > to the datagrid or, 2. Update the dataset, rebind the > > > > > > datagrid and > > > > > > > > from the dataset update the db > > > > > > > > > > > > > > > > The datastructure is somewhat complex (two tables in the > > > > > > dataset and > > > > > > > > each table draws from multiple tables in the db) and > > > > every edit > > > > > > > > should be written back to the db. Do you recommend 1 or 2? > > > > > > > > > > > > > > > > Thanks. > > > > > > > > > > > > > > > > > -----Original Message----- > > > > > > > > > From: dotnet discussion > > > > > > > > [mailto:[EMAIL PROTECTED]]On Behalf > > > > > > > > > Of Shawn > > > > > > > > Wildermuth > > > > > > > > > Sent: Monday, April 15, 2002 3:56 PM > > > > > > > > > To: [EMAIL PROTECTED] > > > > > > > > > Subject: Re: [DOTNET] updating dataset and dataform > > > > > > > > > > > > > > > > > > > > > > > > > > > The DataAdapter usually only updates a single Table at a > > > > > > > > time. If you > > > > > > > > > send a DataSet to the Update (as in > > > > > > > > dataAdapter.Update(dataSet)), it > > > > > > > > > will attempt to update a table called "Table". Probably > > > > > > > > not what you > > > > > > > > > want. > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > 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. > > > > > > > > > > > > > > > > > > > > > > > > > > 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. > > > > > > > > > > > > > > > > > > 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. > > > > > > > > > > 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. > > 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.
