how to prevent the edition of a line when it is already in edit mode

Question

1.00/5 (1 vote)

See more:

Hello to all

I have an application in LAN on a page that contains a GridView I want to disable or prevent
The edition of a line when it is already in edit mode by another user

Thank you.

Posted 6-Dec-13 23:12pm

Member 10324974

Add a Solution

Comments

bbirajdar 7-Dec-13 5:32am

http://blog.sqlauthority.com/2007/04/27/sql-server-2005-locking-hints-and-examples/

Mahesh Bailwal 7-Dec-13 6:06am

One way of doing this is to have database field which you can use as lock. Where whenever any user enter edit mode this field value should changed to 1 and when user is out of edit mode value should be changed to 0. Now when any user tries to add new line check this filed value and stop him accordingly.

Sergey Alexandrovich Kryukov 7-Dec-13 23:59pm

The whole approach is bad...
—SA

1 solution

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)

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) · Answer 1 · 2013-12-07T19:48:00

You should not prevent the edition, instead use Transactions in SQL.
It will automatically handle the transaction and queue the requests.

If somebody already edited the row and you want to edit it, so that's not problem as the Primary KeyID is the same.
The problem will occur if the row is deleted, for that you need to check if that row still exists in Table or not.
If exists, then only update.