title: how to maintain database integrity for write operations in a website
body: <ul>
  <li><p>A website to change add records delete etc</p>
  
  <ul>
  <li>website is not connected architecture, so i cant expect sql to refuse writes to a table being edit by some one else also. As data is only written when its sent back to server by the grid..</li>
  </ul></li>
  </ul>
  
  <p>so is there a way using c# and asp.net, some code , by which i cant explicitly tell the sql server to lock the table, so that viewing is allowed but writing to it gives error like</p>
  
  <p>"sorry another user is using the writting function for this table please wait".</p>