c# - Rolling Back a SQL Server query -

i found few links regarding rolling sql server query have had problems implementing it. since information inserting , updating needs correct need make sure working beforehand. now, have try/catch block, , know rollback goes catch block. example, code:

using (sqlconnection conn5 = new sqlconnection(connstring))  {     try      {         string query = "insert query";         sqlcommand cmd = new sqlcommand(query, conn5);         // parameters          conn5.open();         cmd.executenonquery();     }     catch      {          cmd.rollback();     } } 

i tried cmd.rollback() blew in face.

you open transaction scope. automatically perform rollback unless complete() method called.

using (var tscope = new transactionscope()) using (sqlconnection conn5 = new sqlconnection(connstring))  {   string query = "insert query";   sqlcommand cmd = new sqlcommand(query, conn5);   parameters    conn5.open();   cmd.executenonquery();    // if exception thrown, call complete() never reached ,   // changes rolled back.   tscope.complete(); }