ObjectDataSource, Opportunistic Concurrency, Typed Dataset and timestamp field question

J

J055

Hi

I'd like to use the timestamp and primary key fields to check Opportunistic
Concurrency violations rather than having to compare all values as is the
suggested method when using the ObjectDataSource.

The timestamp field is read-only in the DataTable (this seems logical).
This means I can't save the original value before an Update which I need to
get from the ObjectDataSource.

Does anyone have a suggestion?

Many thanks

Andrew
 
W

Walter Wang [MSFT]

Hi Andrew,

After reviewing your question, I'm still not clear on some points. So if
I've misunderstood anything, please feel free to post here.

By means of "rather than having to compare all values", do you mean change
the ConflictDetection property of ObjectDataSource to OverwriteChanges
instead of CompareAllValues?

I suggest you add the timestamp field to DataKeyNames of the data bound
control along with the primary key. Thus they will both be passed to the
Update method of ObjectDataSource. Then you can compare the timestamp with
the one stored in underlying DataTable to see if gets changed by someone
else.

Hope this helps. Please feel free to post here if anything is unclear.

Sincerely,
Walter Wang ([email protected], remove 'online.')
Microsoft Online Community Support

==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================

This posting is provided "AS IS" with no warranties, and confers no rights.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,769
Messages
2,569,581
Members
45,056
Latest member
GlycogenSupporthealth

Latest Threads

Top