referesh datagridview after database update in vb.net

Posted by Gbolahan on Stack Overflow See other posts from Stack Overflow or by Gbolahan
Published on 2010-06-11T13:45:57Z Indexed on 2010/06/11 13:53 UTC
Read the original article Hit count: 238

Filed under:
Dim myQuery = "UPDATE table1 SET data= CONCAT (data,'" & vbCrLf & "[ " &       Date.Now() & " ]" & " " & "[" & getCN() & "]" & " " & txtTelenotes.Text & "[ item1 ]" & "') WHERE id='" & txtID.Text & "'"
 myCommand.Connection = conn
 myCommand.CommandText = myQuery

 myAdapter.SelectCommand = myCommand
 Dim myData As MySqlDataReader
 myData = myCommand.ExecuteReader()

 txtTelenotes.Text = ""
 dgvREcord.Refresh()

tried refreshing the datagridview using

  dgvREcord.Refresh()

but it does not load the changes form the database.

Any help Pls..

Thanks.

© Stack Overflow or respective owner

Related posts about vb.net