报错：ROLLBACK TRANSACTION 请求没有对应 BEGIN TRANSACTION解决办法

报错：ROLLBACK TRANSACTION 请求没有对应 BEGIN TRANSACTION

C# code

        private static void Prepare(SqlConnection con, SqlCommand cmd, CommandType cmdType, string cmdText, SqlParameter[] cmdParms)        {            con.ConnectionString = ConnectionString;            cmd.Connection = con;            cmd.CommandType = cmdType;            cmd.CommandText = cmdText;            if (cmdParms != null)            {                foreach (SqlParameter parm in cmdParms)                    cmd.Parameters.Add(parm);            }            con.Open();        } public static int ExecuteNonQuery(CommandType cmdType, string cmdText, params SqlParameter[] cmdParms)        {            using (SqlConnection con = new SqlConnection())            {                int iResult = -1;                SqlCommand cmd = new SqlCommand();                Prepare(con, cmd, cmdType, cmdText, cmdParms);                SqlTransaction tran = con.BeginTransaction();                try                {                    iResult = cmd.ExecuteNonQuery();                    tran.Commit();                }                catch                {                    tran.Rollback();                    throw;                }                return iResult;            }//end using        }