how do you turn off optimistic concurrency?

[Chris Huddle]

Is there a way to turn off optimistic concurrency in ASP.NET when updating a
record via the oleDBdataAdapter/oleDBcommandBuilder?

If you use the Microsoft ASP.NET tools you can turn it off and thus modify
the SQL statement so that it doesn't include the WHERE portion, but I'm not
sure how to do the same thing in the code. I do my code-behind in VB.
Thanks!

 

[William Ryan]

No, not through thte command builder. It's one of the limitations of it.

If you use the DataAdapterConfiguration wizard though, one of the options
allows you to turn it off.

HTH,

Bill

 

[William \(Bill\) Vaughn]

Using the CommandBuilder implies that you want ADO.NET to construct the
action queries and it is not smart enough to know that you don't want to
worry about collisions. I would simply code my own action queries for the
UPDATE and INSERT commands. My article on the CB might help.
http://www.betav.com/msdn_magazine.htm

--
____________________________________
Bill Vaughn
MVP, hRD
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________