I'm not looking into a certain brand, but examples are welcome, because the chances are slim I'm gonna find them where I live.. so, what should a metal adhesive contain/be made of in order to allow me to glue 2 metal pieces securely?
I have tried a 2 part compound, but it is mostly plastic in nature.. doesn't look metallic when cured.. it is strong, but not resistant to shearing forces.. I need something to allow me not to use rivets or screws and keep a clean look. I do have rivets and screws though..

