Prevent more user from edit in same record proplem

[ahm1985]

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

 

[ahm1985]

can any one answer for me in this question

 

[softhemc]

You don't give any indication of what versions of VS and SQL Server you are using, but look in SQL Server's BOL (Books On Line) - help file - for details on Transactions and on Locking and you should find a number of solutions to your problem specific to your version.

 

[ahm1985]

version of sql is sql server 2005
and visual studio 2008

 

[softhemc]

As I suggested use BOL and look up both Transactions and Locking - using one or both should help resolve your issues.

 

[DaveInIowa]

It may also be helpful to lookup 'database concurrency'.