If you don't want a message to be shown for every iteration, just move the line
MessageBox.Show("Success");
outside the
foreach
loop.
Put a boolean inside the loop that you set to true if the transaction is successful and then outside the loop you add an if-statement.
if (succcess)
MessageBox.Show("Success");