Deleting multiple row by selecting checkbox on Data Gridview

Question

Hi, How can i delete some selected row by checking checkbox on Data grid view, already added checkbox to datagridview but confused to write a code for Delete Button. Thank you,

jo cherry · Answer

Thanks it was helped me

Satyapriya Nayak · Answer

using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.OleDb; namespace Delete_row_checkbox__DataGridview { public partial class Form1 : Form { OleDbDataAdapter oledbda; string ConnectionString = System.Configuration.ConfigurationSettings.AppSettings["dsn"]; string str; OleDbCommand com; public Form1() { InitializeComponent(); } private void btn_delete_Click(object sender, EventArgs e) { int i = 0; List ChkedRow = new List (); for (i = 0; i { if (Convert.ToBoolean(dataGridView1.Rows[i].Cells["chkcol"].Value) == true) { ChkedRow.Add(i); } } if (ChkedRow.Count == 0) { MessageBox.Show("Select one checkbox"); return; } foreach (int j in ChkedRow) { str = "Delete from test where Did='" + dataGridView1.Rows[j].Cells["Did"].Value + "'"; try { using (OleDbConnection con = new OleDbConnection(ConnectionString)) { using (com = new OleDbCommand(str, con)) { con.Open(); com.ExecuteNonQuery(); } } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } MessageBox.Show("Are you sure you want to delete this Record?", "Confirm deletion", MessageBoxButtons.OK); bindgrid(); } private void bindgrid() { dataGridView1.AllowUserToAddRows = false; dataGridView1.Columns.Clear(); DataGridViewCheckBoxColumn col1 = new DataGridViewCheckBoxColumn(); col1.Name = "chkcol"; col1.HeaderText = "CheckBox"; dataGridView1.Columns.Add(col1); OleDbConnection con = new OleDbConnection(ConnectionString); con.Open(); str = "select * from test "; com = new OleDbCommand(str, con); oledbda = new OleDbDataAdapter(com); DataSet ds = new DataSet(); oledbda.Fill(ds, "test"); dataGridView1.DataMember = "test"; dataGridView1.DataSource = ds; } private void Form1_Load(object sender, EventArgs e) { bindgrid(); } } }

Deleting multiple row by selecting checkbox on Data Gridview

Answers (2)