I am trying to delete the selected datas from database with checkboxes. But it doesn't delete the datas. I couldn't understanf the reason. Can you have a look?
int i = 0;
List<int> ChkedRow = new List<int>();
for (i = 0; i <= dataGridView1.RowCount - 1; i++)
{
if (Convert.ToBoolean(dataGridView1.Rows[i].Cells["gid"].Value) == true)
{
ChkedRow.Add(i);
}
}
if (ChkedRow.Count == 0)
{
MessageBox.Show("En az bir checkbox seçiniz!");
return;
}
foreach (int j in ChkedRow)
{
try
{
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
var cmdText = @"DELETE FROM gezilistemiz25 WHERE gid =" + dataGridView1.Rows[j].Cells["gid"].Value + "";
var command = new OleDbCommand(cmdText, conn);
command.ExecuteNonQuery();
conn.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
MessageBox.Show("Kayitlar basariyla eklendi!");