How to delete information in BD using Datagridview?

Question

Can anyone tell me which command should I put to delete from the database using the information of the selected phone? I put it like this:

    SQLcmd.CommandText = ("DELETE FROM usuario WHERE nome = '" & DataGridView3.IsCurrentCellInEditMode & "' ")

but apparently it didn’t work out....

Answer 1

To take the value of datagrid would just be that:

var valordacelular = DataGridView3.CurrentCell.Value;

It is not indicated that you concatenate the direct value in string do not, below how your line would look, but that is not advisable.

SQLcmd.CommandText = ("DELETE FROM usuario WHERE nome = '" & DataGridView3.CurrentCell.Value & "' ");

The correct thing would be for you to add parameters within the String thus:

SQLcmd.CommandText = ("DELETE FROM usuario WHERE nome = @param1");
SQLcmd.CommandType = CommandType.Text;
SQLcmd.Parameters.Add(new SQLiteParameter("@param1", DataGridView3.CurrentCell.Value));