An easy way to use transactions now:
vb.net Code:
  1. Using myScope As New TransactionScope
  2.  
  3.     '' do your database insert/update stuff here.
  4.  
  5. End Using

I'm not sure if this is supported by MySql data adapter though. You could give it a try to see yourself.