public static int ExecuteNoQueryWithTrans( string strSQL) ... { SqlConnection conn =null; SqlCommand cmd = null; SqlTransaction tran = null; int i = 0; try ...{ conn = GetConnection(); conn.Open(); tran = conn.BeginTransaction(); cmd = new SqlCommand(strSQL,conn,tran); i = cmd.ExecuteNonQuery(); tran.Commit(); } catch(System.Data.SqlClient.SqlException e) ...{ tran.Rollback(); } finally ...{ if(conn!=null) conn.Dispose(); if(cmd!=null) cmd.Dispose(); if(tran!=null) tran.Dispose(); } return i;}