Enable optimistic concurrency

Question

0.00/5 (No votes)

See more:

I have a vb.net in vs 2010. I have a local sqlce database 3.5 that I inserted in the project. When I go into the visual data designer and drag a table to it then right click on the tableadapter, and hit the advanced button, the "optimistic concurrency" option is disabled. Meaning, I cant select it. How can I enable it. When I go to update this table it is causing a concurrency error, thus not updating the row. any suggestions?

Posted 6-Feb-12 1:35am

Tony Palumbo

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Dave Kreskowiak · Answer 1 · 2012-02-06T03:41:00

Solution 1

Something isn't adding up. Are you saying that you're using SQLCE in a multiuser environment?? If not, then you shouldn't be having concurrency problems. It sounds as though your code is competing against itself for control of records. Without seeing how you code is retrieving and updating records, it's pretty difficult to tell you what's going on.

Posted 6-Feb-12 3:41am

Dave Kreskowiak

Comments

Tony Palumbo 6-Feb-12 17:58pm

Hi David,

Here is code:

'try
If tempDate = Today And bsRunInformation.Current("UniqueNumber") = Fields(1) Then
frmMain.bsRunInformation.Current("Description") = StripString(Fields(2))
frmMain.Validate()
frmMain.bsRunInformation.EndEdit()
frmMain.TblRunInformationTableAdapter.Update(frmMain.DsSkySkor1.tblRunInformation) 'Soon as I call this I get DBConcurrencyException not handled

'Catch ex As DBConcurrencyException

'End Try
MsgBox("Update current record " & Fields(2))
Else

frmMain.TblRunInformationTableAdapter.FillSingleRow(frmMain.DsSkySkor1.tblRunInformation, Today, Fields(1))
frmMain.bsRunInformation.Current("Description") = StripString(Fields(2))
frmMain.Validate()
frmMain.bsRunInformation.EndEdit()
frmMain.TblRunInformationTableAdapter.Update(frmMain.DsSkySkor1.tblRunInformation)'Soon as I call this I get DBConcurrencyException not handled
'Catch ex As DBConcurrencyException

'End Try
End If

Tony Palumbo · Answer 2 · 2012-02-06T11:58:00

Hi David,

Here is code:

'try
If tempDate = Today And bsRunInformation.Current("UniqueNumber") = Fields(1) Then
frmMain.bsRunInformation.Current("Description") = StripString(Fields(2))
frmMain.Validate()
frmMain.bsRunInformation.EndEdit()
frmMain.TblRunInformationTableAdapter.Update(frmMain.DsSkySkor1.tblRunInformation) 'Soon as I call this I get DBConcurrencyException not handled

'Catch ex As DBConcurrencyException

'End Try
MsgBox("Update current record " & Fields(2))
Else

frmMain.TblRunInformationTableAdapter.FillSingleRow(frmMain.DsSkySkor1.tblRunInformation, Today, Fields(1))
frmMain.bsRunInformation.Current("Description") = StripString(Fields(2))
frmMain.Validate()
frmMain.bsRunInformation.EndEdit()
frmMain.TblRunInformationTableAdapter.Update(frmMain.DsSkySkor1.tblRunInformation)'Soon as I call this I get DBConcurrencyException not handled
'Catch ex As DBConcurrencyException

'End Try
End If