How to update all the name that display in datagridview

[Maria Sungoh]

I have try this but it always give an error

 k = MessageBox.Show(DataGridView1.Rows(e.RowIndex).Cells(e.ColumnIndex).Value.ToString)
            connection.Open()

            p = "UPDATE police_deployment_system.police_profiles SET POLICE_STATION_ID = """ & man & """ where police_deployment_system.police_profiles.POLICE_ID = """ & k & """ "
            Dim cmd As MySqlCommand = New MySqlCommand(p, connection)
            adapter = New MySqlDataAdapter(p, connection)
            adapter.Fill(ds)
            command.CommandText = "Select * from police_profiles"

[Rabbit]

You need to give us the error message.

But if I had to guess, it's because you're using double quotes for your SQL query when SQL uses single quotes for strings.