title: sql rowlock on select statement
body: <p>I have an ASP.Net webpage where the user selects a row for editing. I want to use the row lock on that row and once the user finishes the editing and updates another user can edit that row i.e. How can I use rowlock so that only one user can edit a row?</p>
  
  <p>Thank you</p>