To lock sql when multiple users trying to update details of different users
<p>In my web application , we have list of students and we have staff login. When multiple staff logs in and try to edit two different student details , when a first user opens the page and second user opens page second both trying to update two different student details , on update , the first user data wont get update  while the second user data updates.When checked with the break point, at that time on first user update , it was taking student id of details opened by second user. Tried with Lock but before it could go to the stored procedure , value is changing. Any help appreciated.</p>
