Go to the next row depending on a value from a column in C#

See more:

C#

SQL

DataGridView

T-SQL

So, I am trying to build a piece of code where I am able to depending on a value from a column it will insert that row or not into the database. Basically it will check all the rows that I am trying to insert and see if that is any one with a value column, in this case, with "M".

What I have tried:

<pre>for (int linhas = 0; linhas < dataGridView1.Rows.Count; linhas++)
                    {
                        if (dataGridView1.Rows[linhas].Cells[8].Value.ToString() != "M")
                        {

                            string queryInsert = @"INSERT INTO CIM_Etiquetas(Carga, Referencia, Quantidade, DataEmissao, Linha, Marca, DescricaoWeb, CodProd, TipoEmb, NomePC) VALUES (@Carga, @Referencia, @Quantidade, @DataEmissao, @Linha, @Marca, @DescricaoWeb, @CodProd, @TipoEmb, @NomePC)";
                            cmd = new SqlCommand(queryInsert);
                            cmd.Connection = con;

                            cmd.Parameters.Add(new SqlParameter("@Carga", SqlDbType.VarChar, 11, "Carga"));
                            cmd.Parameters.Add(new SqlParameter("@Referencia", SqlDbType.VarChar, 30, "Referencia"));
                            cmd.Parameters.Add(new SqlParameter("@Quantidade", SqlDbType.Decimal, 11, "Quantidade"));
                            cmd.Parameters.Add(new SqlParameter("@DataEmissao", SqlDbType.SmallDateTime, 11, "DataEmissao"));
                            cmd.Parameters.Add(new SqlParameter("@Linha", SqlDbType.SmallInt, 4, "Linha"));
                            cmd.Parameters.Add(new SqlParameter("@Marca", SqlDbType.VarChar, 11, "Marca"));
                            cmd.Parameters.Add(new SqlParameter("@DescricaoWeb", SqlDbType.VarChar, 150, "DescricaoWeb"));
                            cmd.Parameters.Add(new SqlParameter("@CodProd", SqlDbType.VarChar, 20, "CodProd"));
                            cmd.Parameters.Add(new SqlParameter("@TipoEmb", SqlDbType.VarChar, 8, "TipoEmb"));
                            cmd.Parameters.Add(new SqlParameter("@NomePC", SqlDbType.VarChar, 30, "NomePC"));

                            cmd.Parameters["@Carga"].Value = dataGridView1.Rows[linhas].Cells[0].Value.ToString();
                            cmd.Parameters["@Referencia"].Value = dataGridView1.Rows[linhas].Cells[1].Value.ToString();
                            cmd.Parameters["@Quantidade"].Value = dataGridView1.Rows[linhas].Cells[2].Value.ToString();
                            cmd.Parameters["@DataEmissao"].Value = dataGridView1.Rows[linhas].Cells[3].Value.ToString();
                            cmd.Parameters["@Linha"].Value = dataGridView1.Rows[linhas].Cells[4].Value.ToString();
                            cmd.Parameters["@Marca"].Value = dataGridView1.Rows[linhas].Cells[5].Value.ToString();
                            cmd.Parameters["@DescricaoWeb"].Value = dataGridView1.Rows[linhas].Cells[6].Value.ToString();
                            cmd.Parameters["@CodProd"].Value = dataGridView1.Rows[linhas].Cells[7].Value.ToString();
                            cmd.Parameters["@TipoEmb"].Value = dataGridView1.Rows[linhas].Cells[8].Value.ToString();
                            cmd.Parameters["@NomePC"].Value = System.Environment.MachineName;

                            cmd.ExecuteNonQuery();
                        }
                    }

If that row as a column with that value it will jump to the next row until it's finished. Do you have any ideas how can I solve it?