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.
