delete items from datagridview c# code example
Example 1: how to delete row in datagrid view in c#
private void btnDelete_Click(object sender, EventArgs e)
{
if (this.dataGridView1.SelectedRows.Count > 0)
{
dataGridView1.Rows.RemoveAt(this.dataGridView1.SelectedRows[0].Index);
}
}
Example 2: 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++;
}