?Optimistic Concurrency Control

I was wondering dealing with 'occ' if i make a change to the dataset object and save it to the database..someone who makes the changes after me, thier changes will not take place or what?

I was just trying to get a clearer definition on how 'occ' worked in detail

[270 byte] By [Dpowers] at [2007-12-16]

«« ClickOnce Deployment
»» Is Full Trust broken in BETA 2?

# 1

OCC works like this if you are using the default Cursor Engine setting provided by ADO:

1. User A fetches a row from the database.
2. User B fetches the same row from the database.
3. User B changes her row and submits a successful change to the row at the database.
4. User A modifies his row and attempts to update the row at the database. The Update fails, because the row is compaired to it's original vaules when User B selected the row. Since the compare fails, the database is not modified.

This explanation was plagerized from "Microsoft ADO.NET", ISBN 0-7356-1423-7, published in 2002 and authored David Sceppa.

A very good book, although it covers ADO.NET 1.0. Thanks go to David...

OtisMukinfus at 2007-9-9 >

top of Msdn Tech,Visual C#,Visual C# General...

# 2

I found that Optimistic Concurrency does not work with an SQL Data Source. I was using a DetailView object and trying to do an update. I got no error, but the data was not updated. When I turned off Optimistic Concurrency the update worked as it should. My guess is that all the Old_... variables are not getting initialized or used correctly in the update statement.

On a somewhat related subject, is there any way to lock the table row while doing the edit?

CharlesBrownmiller at 2007-9-9 >

Visual C# Hot Topic

Visual C# New Topic

Visual C#

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech