Select line in datagridwier and write to the database

Question

I have a datagridviwer populated by a query of the sql database, in this datagrid I have a column with a chekbox, now comes my doubt, as I write to the database when the line has been selected by the user in chekbox.

follow my datagrid screen

code today where I do the Insert in the bank but without chekbox working

private void ncheklist()
{
    SqlCommand cmd = new SqlCommand();
    cmd.CommandType = CommandType.Text;
    cmd.CommandText = @"INSERT INTO TBL_CHEKLIST (N_NOTA, CLIENTE, TRANSP, VOLUME, N_CHEKLIST, EMISSAO) 
                      VALUES (@NOTA, @CLIENTE, @TRANSP, @VOLUME, @CHEKLIST, @EMISSAO)";
    cmd.Connection = conex1;
    conex1.Open();

    cmd.Parameters.Add(new SqlParameter("@NOTA", this.txt_nota.Text));
    cmd.Parameters.Add(new SqlParameter("@CLIENTE", this.txt_cliente.Text));
    cmd.Parameters.Add(new SqlParameter("@TRANSP", this.txt_transp.Text));
    cmd.Parameters.Add(new SqlParameter("@VOLUME", this.txt_volume.Text));
    cmd.Parameters.Add(new SqlParameter("@CHEKLIST", this.txt_nchklist.Text));
    cmd.Parameters.Add(new SqlParameter("@EMISSAO", Convert.ToDateTime(txt_dtinicial.Text).ToString("yyyy/MM/dd").Replace("/", "")));

    cmd.ExecuteNonQuery();
    conex1.Close();
}

Answer 1

To check if the CHECKBOX column is checked I do the following way:

// varrendo o dataGrid
for (Int32 index = 0; index < meuGrid.Rows.Count; index++)
{
   //verifica se a linha do grid está com o checkbox ativado
   //cells[0] = corresponde a primeira coluna, ou seja a que possui o CHECKBOX
   if (bool.Parse(meuGrid.Rows[index].Cells[0].FormattedValue.ToString()) == true)
   {
      // executa ação de inserção no banco de dados
   }
}

Answer 2

The name of your column N_CHEKLIST is different where you are setting the parameter name @CHEKLIST. In case it would have to be the same for both.

Answering your question, you would need to treat the code as 'want' save in the bank.

Example:

TBL_CHEKLIST objChek = new TBL_CHEKLIST();

objChek.N_CHEKLIST= (txt_nchklist.Checked == true ? "S" : "N");

In the Insert/Update treat

(!string.IsNullOrEmpty(N_CHEKLIST) ? new SqlParameter("@N_CHEKLIST",txt_nchklist.Text) : new SqlParameter("@N_CHEKLIST", DBNull.Value))};