title: How to do Commit/rollback in sql server using VB.net
body: <p>I'm working on an asp.net application which involves sql server as database. After writing huge function in vb.net, I had to select , insert and update different tables using one n other. I realized that, if all of this executed in one go  then its a win win situation. If all of this doesn't go well then it would create a huge mess.</p>
  
  <p>When we do DML operations in Oracle, we had to </p>
  
  <pre><code>commit;
  
  rollback;
  </code></pre>
  
  <p>after every DML operation. My question is how do we do the same thing in sql server using VB.net.</p>
  
  <p>My search leads to write a procedure @sql server. Inseration and delation will be done via sorted procedure. But I want it as normal operations like</p>
  
  <pre><code>SqlCommand("some query", connection")
  </code></pre>
  
  <p>Is it possible to do commit or rollback without using sorted procedures??</p>
  
  <p>Thanks in advance!</p>