Hi,
Why all this, just update the all tables with the new data whether it's
the same or it's new. Is there any business need for what you are doing?
Best regards,
Mohamed Sharaf
MEA Developer Support Center
ITWorx on behalf Microsoft EMEA GTSC
--------------------
| From:
ne***********@gmail.com
| Newsgroups: microsoft.public.dotnet.framework.aspnet
| Subject: Detecting Changes to a dataform question
| Date: 26 Sep 2005 07:55:47 -0700
| Organization:
http://groups.google.com
| Lines: 26
| Message-ID: <11*********************@g49g2000cwa.googlegroups. com>
| NNTP-Posting-Host: 216.235.146.236
| Mime-Version: 1.0
| Content-Type: text/plain; charset="iso-8859-1"
| X-Trace: posting.google.com 1127746552 23076 127.0.0.1 (26 Sep 2005
14:55:52 GMT)
| X-Complaints-To:
gr**********@google.com
| NNTP-Posting-Date: Mon, 26 Sep 2005 14:55:52 +0000 (UTC)
| User-Agent: G2/0.2
| X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1;
..NET CLR 1.1.4322),gzip(gfe),gzip(gfe)
| Complaints-To:
gr**********@google.com
| Injection-Info: g49g2000cwa.googlegroups.com;
posting-host=216.235.146.236;
| posting-account=4x5ohgsAAACg5EznArV1kEPHmTNHqHa7
| Path:
TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfee d00.sul.t-online.de!t-onli
ne.de!border2.nntp.dca.giganews.com!nntp.giganews. com!postnews.google.com!g4
9g2000cwa.googlegroups.com!not-for-mail
| Xref: TK2MSFTNGXA01.phx.gbl
microsoft.public.dotnet.framework.aspnet:127056
| X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet
|
| 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.
|
|