Insert MYSQL error by data grid view

Question

the code is as follows, I am making an Insert from values of a data grid view

                foreach (DataGridViewRow row in dgvCON.Rows)
                {
                        MySqlCommand cmd = new MySqlCommand();
                        cmd = conectabanco.CreateCommand();
                        if (row.IsNewRow) continue;
                        cmd.Parameters.AddWithValue("@IdProd", row.Cells["Id"].Value);
                        cmd.Parameters.AddWithValue("@QtdProd", row.Cells["Quantidade"].Value);
                        cmd.Parameters.AddWithValue("@NomeProd", row.Cells["Nome"].Value);
                        cmd.Parameters.AddWithValue("@PrecoUnitProd", row.Cells["R$ Unidade"].Value);
                        cmd.Parameters.AddWithValue("@TotalListaConsu", row.Cells["Total"].Value);
                        cmd.CommandText = "INSERT INTO listaconsumo(IdCon, IdProd, QtdProd, PrecoUnitProd, " +
                        "totalListaConsu)VALUES("+idconsumo+", @IdProd, @QtdProd, @NomeProd, @PrecoUnitProd, @totalListaConsu)";

                    cmd.ExecuteNonQuery();
                }

The problem is that when running Sql, it sends the "@Idprod" value itself instead of being replaced by the value of datagridview

Answer 1

Before the amount of VALUES is different from the number of columns in the INSERT, you are not informing the column to the field NomeProd. And where do you pick up row.Cells["R$ Unidade"].Value I believe this is an invalid name for a datagridview column.

Check these questions and give feedback here please

The use to access the value of the line cell, is row.Cells[0].Value where 0 is the index of the column, or row.Cells["key"].Value where key is the name of the object DataGridViewColumn and not the name that appears on the screen. You can access directly by the object DataGridviewColumn informing the property Name. Ex:

row.Cells[nomeDaColuna.Name].Value

Another thing, in the question you said that the @Idprod field was not working, now it’s passed that @Nomeprod is not. Which is right ?

Try it there.