How to delete one to mutlply rows at one time by selecting check box in datagridview in c#

Question

I am having trouble with deleting one to multiply rows in DataGridView by selecting check box and clicking the delete button. When i click the delete button nothing happens and neither appears if there is an error.

Here is my code

SqlConnection cn = new SqlConnection("Data Source=.\\SQLEXPRESS; Initial Catalog=DatabaseName;Integrated Security=True");
    SqlCommand cmd = new SqlCommand();
    SqlDataReader dr;


private void btnDeleteCust_Click(object sender, EventArgs e)
{
    foreach (DataGridViewRow item in gridCustomer.Rows)
    {
        if (bool.Parse(item.Cells[6].Value.ToString()))
        {
            cn.Open();
            cmd.CommandText = "delete from Customer where customerID = '" + item.Cells[0].Value.ToString() + "'";
            cmd.ExecuteNonQuery();

            cn.Close();
        }
    }
}

Use debug and see why nothing happens. Also don't use global connection, command and reader. — mybirthname, Oct 15 '16 at 08:56
put a try catch and see if the app has an error !! i think the problem is with your item.cells[6], try to put nsame instead of index — Amir Ziarati, Oct 15 '16 at 08:57
When you check the CheckBox, do you validate is it checked or not like `CheckBox.Checked == true`? Get the CheckBox index and try doing so. — AT-2017, Oct 15 '16 at 09:03

score 0 · Accepted Answer · answered Oct 15 '16 at 09:14

0

What I can see you didn't check whether the CheckBox is checked or not as follows:

if(Convert.ToBoolean(row.Cells["checkBoxColumn"].Value) == true)

Get the index or position of the CheckBox that are being checked and finally their ids to delete.

For more, see this link - Delete Rows With CheckBox in DataGridView

answered Oct 15 '16 at 09:14

AT-2017

3,114
3
23
39

Hi it works but i having having a problem with the datagridview as its not refreshing after the row has been deleted – jessmh1 Oct 16 '16 at 06:48
cn.Open(); cmd.CommandText = "delete from Customer where customerID = '" + item.Cells[0].Value.ToString() + "'"; cmd.ExecuteNonQuery(); gridCustomer.Update(); cleartxt(); MessageBox.Show("Successfully Deleted"); cn.Close(); – jessmh1 Oct 16 '16 at 06:58
I have have put that it in and is still not refreshing – jessmh1 Oct 16 '16 at 06:59
No it is not refreshing the datagridview – jessmh1 Oct 16 '16 at 07:01
Try this - `gridCustomer.Refresh(); gridCustomer.Update();` – AT-2017 Oct 16 '16 at 07:02
See this - http://stackoverflow.com/questions/14374348/refresh-button-refreshing-data-grid-view-after-inserting-deleting-updating – AT-2017 Oct 16 '16 at 07:13
Did you write any method to show the data in `DataGridView`? If so, share it or put it inside the button click event at the end like `ShowData();`. – AT-2017 Oct 16 '16 at 07:29
Yeah i did that – jessmh1 Oct 16 '16 at 07:38
loadgridCustomer(); – jessmh1 Oct 16 '16 at 07:40
Make sure to put the method at the end of the button click event. – AT-2017 Oct 16 '16 at 07:40
Error display The connection was not closed. The connection's current state is open – jessmh1 Oct 16 '16 at 07:41
Make sure to close the `Con.Open()` and `Con.Close()` or for the reader, do the same. – AT-2017 Oct 16 '16 at 07:42

How to delete one to mutlply rows at one time by selecting check box in datagridview in c#

1 Answers1