title: How to know whether a sql Update statement executed successfully or failed?
body: <p>How to know whether a sql Update statement executed successfully or failed ?</p>
  
  <p>I use sql server 2005 and C# asp.net.</p>
  
  <p>Can I get the successful or failed infomation in C# without adding some sql code into the old sql statement?</p>