ho fatto tanti tentativi che non mi va.
mi dice il problema è executenonquery e non so come si risolve?

ecco codice:

Dim connection As New MySqlConnection(connStr)
For i = 0 To Me.DataGridView1.Rows.GetRowCount(DataGridViewElem entStates.Selected) - 1
Dim ID As String = "Me.DataGridView1.SelectedRows(i).Cells('nome').Va lue"

'ID = (DataGridView1.SelectedColumns(i).Index.ToString(" nome"))
query = "DELETE FROM operatori WHERE nome = " & ID & ";"
Dim cmd As New MySql.Data.MySqlClient.MySqlCommand(query, connection)
cmd.Connection.Open()
cmd.ExecuteNonQuery()
cmd.Connection.Close()

Next