I bought these two as a test, wore them all day, did push ups, etc. Both stayed in place throughout the day. I will try on the first linked bra with my dress tomorrow. Second linked worked, but the side panels are visible.

Niidor Adhesive Bra Strapless... https://www.amazon.com/dp/B075V4JSWR?ref=ppx_pop_mob_ap_share

MITALOO Push Up Strapless Sticky... https://www.amazon.com/dp/B096R93DWB?ref=ppx_pop_mob_ap_share