Trying to delete selected row from datagridview but it is deleting multiple rows

Chandni Vishen

It is a simple question, but since I am new to C#, I am not sure how to solve this. Basically, I have a datagridview that displays records from MySQL table. I have a delete button, which by clicking performs the sql query, which is working fine, and is also meant to then delete the selected row from datgridview. But what actually happening, is it deletes multiple rows even when only one row is selected. Here is the query:

    private void delete_btn_Click(object sender, EventArgs e)
    {
        foreach (DataGridViewRow row in dataGridView1.Rows)
        {
            string constring = @"server = localhost; user id = root; password = pass; persistsecurityinfo = false; database = mapping; allowuservariables = false";
            using (MySqlConnection con = new MySqlConnection(constring))
            {
                using (MySqlCommand cmd = new MySqlCommand("UPDATE deletion SET date_time = UTC_TIMESTAMP() where product_id =" + proid_txtbx.Text, con))
                {
                    cmd.Parameters.AddWithValue("@product_id", row.Cells["product_id"].Value);
                    cmd.Parameters.AddWithValue("@product_name", row.Cells["product_name"].Value);
                    cmd.Parameters.AddWithValue("@category_id", row.Cells["category_id"].Value);
                    cmd.Parameters.AddWithValue("@date_time", row.Cells["date_time"].Value);
                    con.Open();
                    cmd.ExecuteNonQuery();
                }
                foreach(DataGridViewRow item in this.dataGridView1.SelectedRows)
                {
                   dataGridView1.Rows.RemoveAt(this.dataGridView1.SelectedRows[0].Index);
                }
            }
        }

Screenshots: Row 6 should be deleted: enter image description here Other Rows are deleted when I click Delete button enter image description here

Anant Dabhi

I think your problem is with your foreach loop. You are looping through all your rows with dataGridView1.Rows. Tr dataGridView1.SelectedRows instead:

foreach (DataGridViewRow row in dataGridView1.SelectedRows)
    if (!row.IsNewRow) dataGridView1.Rows.Remove(row);

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at
0

Comments

0 comments
Login to comment

Related

From Dev

"On Delete Cascade" if deleting a row from the child table

From Dev

Deleting multiple rows from a table

From Dev

Delete selected images from a row containing multiple cells in UITableView

From Dev

Need to get the first cells of a selected row in datagridview before delete it

From Dev

Deleting multiple rows in datagridview

From Dev

how to delete selected rows (multiple rows) from CheckboxTableViewer when button clicks? (table is connected to oracle database)

From Dev

How to delete rows checked as false from datagridview

From Dev

How to delete selected rows from a DataGridView?

From Dev

Count values from selected rows from dataGridView

From Dev

MySQL IN only deleting single row, should delete multiple from variable - PHP

From Dev

How to delete last row in DataGridView and keep the row selected?

From Dev

Removing the selected rows from a DataGridView

From Dev

List of deleting rows in datagridview

From Dev

Stored procedure: delete rows from multiple tables with output for every row

From Dev

Deleting multiple rows from a table

From Dev

Trying to combine multiple rows from a table into one row

From Dev

Delete selected images from a row containing multiple cells in UITableView

From Dev

print selected row from datagridview Error

From Dev

Deleting data of rows selected from object?

From Dev

Count values from selected rows from dataGridView

From Dev

jqgrid - Delete multiple selected rows

From Dev

Delete row from DataGridView via button on the row

From Dev

Delete multiple selected rows in phalcon

From Dev

Removing the selected rows from a DataGridView

From Dev

Deleting multiple rows from TableView

From Dev

how to delete selected row from datagridview

From Dev

Delete multiple rows while using the id from the row before

From Dev

How to delete selected row from datagridview and database?

From Dev

Index was out of range after deleting multiple rows from the datagridview? C#

Related Related

  1. 1

    "On Delete Cascade" if deleting a row from the child table

  2. 2

    Deleting multiple rows from a table

  3. 3

    Delete selected images from a row containing multiple cells in UITableView

  4. 4

    Need to get the first cells of a selected row in datagridview before delete it

  5. 5

    Deleting multiple rows in datagridview

  6. 6

    how to delete selected rows (multiple rows) from CheckboxTableViewer when button clicks? (table is connected to oracle database)

  7. 7

    How to delete rows checked as false from datagridview

  8. 8

    How to delete selected rows from a DataGridView?

  9. 9

    Count values from selected rows from dataGridView

  10. 10

    MySQL IN only deleting single row, should delete multiple from variable - PHP

  11. 11

    How to delete last row in DataGridView and keep the row selected?

  12. 12

    Removing the selected rows from a DataGridView

  13. 13

    List of deleting rows in datagridview

  14. 14

    Stored procedure: delete rows from multiple tables with output for every row

  15. 15

    Deleting multiple rows from a table

  16. 16

    Trying to combine multiple rows from a table into one row

  17. 17

    Delete selected images from a row containing multiple cells in UITableView

  18. 18

    print selected row from datagridview Error

  19. 19

    Deleting data of rows selected from object?

  20. 20

    Count values from selected rows from dataGridView

  21. 21

    jqgrid - Delete multiple selected rows

  22. 22

    Delete row from DataGridView via button on the row

  23. 23

    Delete multiple selected rows in phalcon

  24. 24

    Removing the selected rows from a DataGridView

  25. 25

    Deleting multiple rows from TableView

  26. 26

    how to delete selected row from datagridview

  27. 27

    Delete multiple rows while using the id from the row before

  28. 28

    How to delete selected row from datagridview and database?

  29. 29

    Index was out of range after deleting multiple rows from the datagridview? C#

HotTag

Archive