Here is my problem.
This is using a FormView and a SqlDataSource.
On Updating, I need to compare the old values (orignal values returned
from Database) against the updated values. If there are changes I need
to do some processing.
The Updating method gives me access to the current variables, but I am
unsure how to get hold of the orignal values.
If I switch on Optimistic concurrency on my SqlDataSource, the old
parameters can be accessed from the same collection as my new
parameters. Unfortunately, we have a number of screens already written
and when I try and edit the SqlDataSource settings, I cannot access the
Advance button to turn Optimistic concurrency on (I I hadn't switched it
on orignally).
The SqlDataSource contains quit a lot of custom written Sql (over the
top of the generated Sql) so we dont want to be changing that.
anyone got any suggestions, or perhaps a way of turning optimistic
concurrency on for the SqlDataSoure in code perhaps?
*** Sent via Developersdex
http://www.developersdex.com ***
Similar Threads
