Hello Guys,

I'm having problem on how will i restrict the user to edit certain records if it is being used by another user.

Scenario :

Person A currently editing Customers table having CustomerID(pk) of 1
Person B also wants to edit the same record (CustomerID(pk) of 1)

In this case, my web app should prompt the Person B that "It is being use by another person" or prompt him to try again later.

By the way, Im using MSSQL 2008 R2 C#.NET 4.0 and asp.net 4.0.

Thanks.