By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,705 Members | 2,013 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,705 IT Pros & Developers. It's quick & easy.

how to clear a concurrency violation error - grid editing?

P: n/a
Hi,

I have an app which retrieves data from a sql server table
and displays it on a datagrid. If 2 sessions of this app
are running and 2 users try to update the same record at
about the same time, one of the apps will yield a
concurrency violation error. The app with the error will
have a little red error symbol next to the record in the
datagrid, and the only way I can make the error go away
for now is to restart that session. Is there a way to
clear this error without having to restart the app?

TIA
Jerry
Nov 20 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
There is a lot of concurrency issues in David Sceppas book.

there are numerous ways that you can deal with this, including event
handling in your data Adapters, comparing datasets, etc...

a little more info on how your updating would be appreciated.

-CJ

"Jerry" <an*******@discussions.microsoft.com> wrote in message
news:7a****************************@phx.gbl...
Hi,

I have an app which retrieves data from a sql server table
and displays it on a datagrid. If 2 sessions of this app
are running and 2 users try to update the same record at
about the same time, one of the apps will yield a
concurrency violation error. The app with the error will
have a little red error symbol next to the record in the
datagrid, and the only way I can make the error go away
for now is to restart that session. Is there a way to
clear this error without having to restart the app?

TIA
Jerry

Nov 20 '05 #2

P: n/a
Thanks. I did a search on google for this and found some
articles that show how to add a handler for the
dataAdapter update event. I tried that and can now sort
of trap when the concurrency violation occurs. My fix
after trapping the error is to alert the 2nd user that the
current record is already being edited and then to clear
the dataset for that user and refill it from the adapter.

I will take a look at the book you suggest. Thanks for
your reply.

Jerry.

-----Original Message-----
There is a lot of concurrency issues in David Sceppas book.
there are numerous ways that you can deal with this, including eventhandling in your data Adapters, comparing datasets, etc...

a little more info on how your updating would be appreciated.
-CJ

"Jerry" <an*******@discussions.microsoft.com> wrote in messagenews:7a****************************@phx.gbl...
Hi,

I have an app which retrieves data from a sql server table and displays it on a datagrid. If 2 sessions of this app are running and 2 users try to update the same record at
about the same time, one of the apps will yield a
concurrency violation error. The app with the error will have a little red error symbol next to the record in the
datagrid, and the only way I can make the error go away
for now is to restart that session. Is there a way to
clear this error without having to restart the app?

TIA
Jerry

.

Nov 20 '05 #3

P: n/a
Hi,

http://www.syncfusion.com/FAQ/WinFor...c44c.asp#q878q

Ken
---------------
"Jerry" <an*******@discussions.microsoft.com> wrote in message
news:7a****************************@phx.gbl...
Hi,

I have an app which retrieves data from a sql server table
and displays it on a datagrid. If 2 sessions of this app
are running and 2 users try to update the same record at
about the same time, one of the apps will yield a
concurrency violation error. The app with the error will
have a little red error symbol next to the record in the
datagrid, and the only way I can make the error go away
for now is to restart that session. Is there a way to
clear this error without having to restart the app?

TIA
Jerry

Nov 20 '05 #4

P: n/a
Thanks,
Great resource!

Jerry

-----Original Message-----
Hi,

http://www.syncfusion.com/FAQ/WinFor...c44c.asp#q878q

Ken
---------------
"Jerry" <an*******@discussions.microsoft.com> wrote in messagenews:7a****************************@phx.gbl...
Hi,

I have an app which retrieves data from a sql server table and displays it on a datagrid. If 2 sessions of this app are running and 2 users try to update the same record at
about the same time, one of the apps will yield a
concurrency violation error. The app with the error will have a little red error symbol next to the record in the
datagrid, and the only way I can make the error go away
for now is to restart that session. Is there a way to
clear this error without having to restart the app?

TIA
Jerry

.

Nov 20 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.