update database when datagridview changes

[adsaca]

here's my code in filling a datagridview,which i retrieve from database mysql,

        dim sql as String
        sql = "SELECT * FROM table_user"
        Dim myData As New DataTable
 
        comm.Connection = conn
        conn.Open()
 
       ' comm.CommandType = CommandType.Text
        comm.CommandText = sql
        myAdapter.SelectCommand = comm
        myAdapter.Fill(myData)
 
 
       DataGridView1.DataSource = myData
 
 

So here's my question(just as you read from my title),
how to update database when values in the datagrid change?

please help,
arjel

[adsaca]

i've already found a solution to my problem, and here's what i did.

 
myAdapter.Update(myData , "table_user")