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: 241
vb.net
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