How to apply a Transaction and Rollback in VB.Net ?

Hi All Experts,

I am using the following code to store(insert / update SQL statement) a data to MySQL 4.1 Server. I want to know is it possible to add the "Transaction" and "Rollback" functions to my situtation.

My Code here:
    Public Function setSQLcommandAdapter(ByVal connection_str As String, ByVal SQL_str As String) As Boolean
        Dim conn As New MySqlConnection
        Dim myCommand As New MySqlCommand

        conn.ConnectionString = connection_str
        Try
            conn.Open()
            Try
                myCommand.Connection = conn
                myCommand.CommandText = SQL_str
                myCommand.ExecuteNonQuery()
                conn.Close()
                conn.Dispose()
                Return True
            Catch myerror As MySqlException
                MsgBox("There was an error reading from the database: " & myerror.Message)
                Return False
            End Try
        Catch myerror As MySqlException
            MessageBox.Show("Error connecting to the database: " & myerror.Message)
            Return False
        Finally
            If conn.State <> ConnectionState.Closed Then conn.Close()
        End Try
    End Function