Re: Detecting Changes to a dataform question

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



normally you keep the old values, and check that they still match (someone
else hasn't changed the record). this means it better to detect user changes
independant of the database. datasets are common for this.

-- bruce (sqlwork.com)




<needin4mation@xxxxxxxxx> wrote in message
news:1127746547.006281.61510@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Hi, I have an asp.net 1.1 application that populates data from a
> database. When the user changes data, they have to hit a button to
> update the data. The data entry form (same form that is populated) is
> from several different tables. To the user, of course, this is not
> seen.
>
> Scenario: After the page is populated, assume a change is made to the
> form and the user hits update. The page then goes back, reads the
> database for that record and then compares the results to what the user
> typed in. If it is the same, it goes to the next set of controls to
> check. If it is diffent, it does an update mytable set to the
> database.
>
> Example: An address:
>
> The populate form has 123 Main St. MyTown, CA. 999999
>
> The user changes this to 124 Main St. Dallas, Tx. 4444477
>
> The user hits update. The database reads the database. It gathers
> values. It compares the values to what the user submitted just now and
> if there are changes, it updates that row. If not it leaves it.
>
> My question is is this the wrong way to do it? It "feels" wrong.
> Thanks.
>


.



Relevant Pages

  • Re: Binding DateTimePicker
    ... unless the user changes this date it is not saved to database ... It seems that there is some "Modified" property for every control. ... The value isn't persisted if the modified flag ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Unable to bind untyped dataset to textboxes, anyone done this?
    ... >couple of textboxes in a form, so that when a user changes a value, it's ... >eventually reflected back to the database. ... > dtTagDetails, but since the third parameter is null, nothing is sent back ...
    (microsoft.public.dotnet.framework.windowsforms.databinding)
  • Re: How do I save information with multiple users in the database?
    ... one user changes a record, it will be locked to other users. ... set the refresh interval to display new information. ... >I have a database that multiple users enter information. ... Prev by Date: ...
    (microsoft.public.access.gettingstarted)
  • Re: C#, grid and databinding
    ... to a dataset - this is just whatever you retrieved from the database. ... figure out where and how it should update when the user changes something on ... somehow monitor the database automatically waiting for changes - not to ... in the grid that now got updated in the database, ...
    (microsoft.public.dotnet.languages.csharp)
  • Change color of cell after user has input a number
    ... I have a spreadsheet that populates a number of cells. ... Now, ifthe user changes a value, I want the ...
    (microsoft.public.excel.misc)