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.
