how do u Insert Datatable to Mysql server ?

[alcoholicone]

I wish to insert a filled datatable to a mySQL table, the coloum names are the same in the tabletable as the mySQL table (name,guid,count) but i am unsure how to do it. i already have a connection string and a mySQLdataAdapter, but just not sure how to use them for inserting lol.

            Dim Adapter As MySqlDataAdapter
            Dim CommandBuild As MySqlCommandBuilder
            Dim myDataTable as new datatable
            Dim myConnString = "Server=larlar;" & _
            "Database=larlar;" & _
            "Uid=larlar;" & _
            "Pwd=larlar;" & _
            "Connect Timeout=30;"
            Dim myConnection As New MySqlConnection(myConnString)

any ideas ?

thx