Can someone help with following issue? How do I delete an row from DataGridView and same changes occur in MySQL with the code below

Dim connDatagrid As New MySqlConnection

Dim myCommand As New MySqlCommand

Dim queryDatagrid As String

Dim myCommandBuilder = New MySqlCommandBuilder(myAdapter)

Dim ConnectionString = "server=127.0.0.1;" & "uid=root;" & "pwd=;" & "database=phonebook;"

'LabelPrint.Visible = True

ButtonErase.Enabled = False

queryDatagrid = "delete from vnstelefon where id = '" + IdErase.ToString + "'"

Try

Try

'myCommand.Parameters.Remove("Delete from vnstelefon where id = '" + IdErase.ToString + "'")

'myAdapter.

queryDatagrid = "select * from phone"

Catch myerror As MySqlException

MsgBox("There was an error reading from the database: " & myerror.Message)

End Try

Catch myerror As MySqlException

MessageBox.Show("Error connecting to the database: " & myerror.Message)

Finally

If connDatagrid.State <> ConnectionState.Closed Then connDatagrid.Close()

End Try

Refer to following

Public Function CreateCmdsAndUpdate(myDataSet As DataSet, myConnection As String, mySelectQuery As String, myTableName As String) As DataSet
Dim myConn As New OleDbConnection(myConnection)
Dim myDataAdapter As New OleDbDataAdapter()
myDataAdapter.SelectCommand = New OleDbCommand(mySelectQuery, myConn)
Dim custCB As OleDbCommandBuilder = New OleDbCommandBuilder(myDataAdapter)

myConn.Open()

Dim custDS As DataSet = New DataSet
myDataAdapter.Fill(custDS)

' Code to modify data in DataSet here

DataGirdViewTele.Rows.Remove(row); //remove a row

' Without the OleDbCommandBuilder this line would fail.
myDataAdapter.Update(custDS)

myConn.Close()

CreateCmdsAndUpdate = custDS
End Function 'SelectOleDbSrvRows

Refer to following

Public Function CreateCmdsAndUpdate(myDataSet As DataSet, myConnection As String, mySelectQuery As String, myTableName As String) As DataSet
Dim myConn As New OleDbConnection(myConnection)
Dim myDataAdapter As New OleDbDataAdapter()
myDataAdapter.SelectCommand = New OleDbCommand(mySelectQuery, myConn)
Dim custCB As OleDbCommandBuilder = New OleDbCommandBuilder(myDataAdapter)

myConn.Open()

Dim custDS As DataSet = New DataSet
myDataAdapter.Fill(custDS)

' Code to modify data in DataSet here

DataGirdViewTele.Rows.Remove(row); //remove a row

' Without the OleDbCommandBuilder this line would fail.
myDataAdapter.Update(custDS)

myConn.Close()

CreateCmdsAndUpdate = custDS
End Function 'SelectOleDbSrvRows