I have Below requirement
Web have web application , there is a page we display one record from table called "TableA".
The user has option to go to next record or mark it as complete by clicking on complete button .
The requirement is when the record is displayed on the screen , that record should be locked for that user and for any other users that record should not displayed until the current user closes the application or session time out or complete it
We are using asp.net and Sql server database
Pls let me know how to achieve this ?