title: Disable read/write to a table via SqlTransaction in .net?
body: <p>How to use SqlTransaction in .net 2.0 so that when I start reading data from a table, that table is blocked for others (other programs) to read/write to that table?</p>
  
  <p>If SqlTransaction is not a good option, than what is?</p>