C # data rollback

Public int getexectequery (string straddsql, string strupdatesql, string strdelsql) {sqlconnection conn = new sqlconnection (system. configuration. configurationsettings. appsettings ["gpsp_ SQL"]); // instantiate a data connection // sqlconnection conn = new sqlconnection (conn_string); Conn. open (); sqlcommand command = Conn. createcommand (); sqltransaction transaction = NULL; transaction = Conn. begintransaction (); command. connec Tion = conn; command. Transaction = Transaction; int COUNT = 0; try {If (straddsql! = "") {Command. commandtext = "insert into a..."; command. executenonquery () ;}if (strupdatesql! = "") {Command. commandtext = "insert into B..."; Count = command. executenonquery () ;}if (strdelsql! = "") {Command. commandtext = "insert into C ..... "; Count = command. executenonquery ();} transaction. commit ();} catch {transaction. rollback ();} return count ;}