delete button in datagridview c# code example

Example: delete button in datagridview c#

int i = 0;
        private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {
            if (dataGridView1.Columns[e.ColumnIndex].Name == "btndelete")
            {
                using (OleDbConnection conn = new OleDbConnection(sqlCon))
                {
                    conn.Open();
                    using (OleDbCommand cmd = conn.CreateCommand())
                    {
                        int id;
                        if (this.i > 0)
                        {
                            id = Convert.ToInt32(this.dataGridView1.Rows[e.RowIndex].Cells[1].Value);
                        }
                        else
                        {
                            id = Convert.ToInt32(this.dataGridView1.Rows[e.RowIndex].Cells[0].Value);
                        }
                        cmd.CommandText = @"delete from Table1 where ID=" + id;
                        int i = cmd.ExecuteNonQuery();
                        if (i > 0)
                            MessageBox.Show("Deleted.");
                    }
                }
            }
            dataGridView1.DataSource = BindSource();
            i++;
        }