CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2014
    Posts
    29

    Prevent more user from edit in same record

    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

  2. #2
    VictorN's Avatar
    VictorN is offline Super Moderator Power Poster
    Join Date
    Jan 2003
    Location
    Hanover Germany
    Posts
    20,396

    Re: Prevent more user from edit in same record

    Victor Nijegorodov

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  





Click Here to Expand Forum to Full Width

Featured