How Prevent more user from edit in same recorddo I...

Question

1.00/5 (1 vote)

See more:

suppose i need to make update the employee as following
CREATE PROC UPDATE_EMPLOYEE
(
@EmployeeID INT,
@EmployeeName NVARCHAR(50)
)
AS
update Employee set EmployeeName=@EmployeeName where EmployeeID=@EmployeeID
Suppose I have two useres A,B
A modified or edit using stored procedure above employee no 5000 field EmployeeName
B need to modify employee no 5000 using stored procedure above field EmployeeName
i need to prevent user B To modify same record using time stamp How to do that from c# code and sql server and what modification in stored procedure to accept timestamp
EmployeeTable
EmployeeID
EmployeeName
TimeStampEmp
Meaning allow to another user after specified time

Posted 25-Feb-15 9:34am

ahmed_sa

Add a Solution

Comments

[no name] 25-Feb-15 15:38pm

Think again about whether you really have to prevent. Is it a difference whether B modifies after 1milliSec or by Chance 5Sec ("the specified time") after A modified it?

ZurdoDev 25-Feb-15 16:02pm

Where are you stuck?

HKHerron 25-Feb-15 16:16pm

I think he is trying to prevent 2 people from editing the same record at the same time??

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)

Dave Kreskowiak · Answer 1 · 2015-02-25T10:29:00

You don't prevent 2 people from editing the same record at the same time. You check this when you go to write the data to the database.

You have a couple of options.

1) The last write to the database always wins. No checking involved. You simple just write the record to the database and whoever gets there last is considered the most current and correct data.

2) You go to write the data to the database and in your SQL UPDATE statement, you set your WHERE clause to include every field in the table, not just the record ID. This way, if the "records affected" value comes back with anything other than 1, you know the data was changed between the time it was retrieved and the time you're trying to save it again.