update database when datagridview changes

adsaca

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

Expand|Select|Wrap|Line Numbers

 
        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.

Expand|Select|Wrap|Line Numbers

myAdapter.Update(myData , "table_user")

update database when datagridview changes

re: update database when datagridview changes

Similar Visual Basic .NET bytes

/bytes/development

/bytes/it

/bytes/about