Datagridviews checkbox cells are always null. How can I fix it?

Question

I have a datagridview. Its first cell has a CheckBox column. I want to find the selected CheckBox row. "cells[0].value = null" always.

foreach (DataGridViewRow row in dataGridView1.Rows)
{

   if ((Convert.ToBoolean(row.Cells[0].Value) == true )) 
    {
        SqlCommand komut = new SqlCommand("insert into üreticiFirma (firma_ismi,konum,hammadde_isim,alıs_maliyeti,stok)values(@param2,@param3,@param4,@param5,@param6)", baglanti);

        komut.Parameters.AddWithValue("@param2", lblFirma.Text);
        komut.Parameters.AddWithValue("@param3", lblKonum.Text);
        komut.Parameters.AddWithValue("@param4", Convert.ToString(txtHammadde.Text));
        komut.Parameters.AddWithValue("@param5", Convert.ToInt32(row.Cells[7].Value));
        komut.Parameters.AddWithValue("@param6", txtMiktar.Text);
        komut.ExecuteNonQuery();
    }
}

Not enoguht code provided.. Please provide the generated DataGridView code. — Avi Meltser, May 07 '19 at 12:23
Check this: https://stackoverflow.com/questions/1237829/datagridview-checkbox-column-value-and-functionality — NoChance, May 07 '19 at 13:06

score 0 · Answer 1 · edited May 07 '19 at 13:10

            baglanti.Open();
            SqlCommand komut = new SqlCommand("Select * from hammaddeler", 
                               baglanti);
            SqlDataAdapter ad = new SqlDataAdapter(komut);
            DataTable dt = new DataTable();
            ad.Fill(dt);
            dataGridView1.DataSource = dt;
            baglanti.Close();

            private System.Windows.Forms.DataGridView dataGridView1;
            private System.Windows.Forms.DataGridViewCheckBoxColumn Column1;

Datagridviews checkbox cells are always null. How can I fix it?

1 Answers1