All that effort for nothing with 水の泡になる
水の泡になる means all the effort put into something becomes for nothing. 水の泡となる may also be used.
Similar expressions in English include “go up in flames”, “go up in smoke”, “go down the drain”, and “gone to waste”.
名探偵コナン » Volume 5 » Page 83