Home / Questions / 225720
Accepted
Alejandro Estupiñán
Asked: 2020-12-27 16:01:38 +0800 CST 2020-12-27 16:01:38 +0800 CST

Error deleting records from a DataGridView

  • 772

My code does not show errors but when I want to use the button it throws me this error, I would like to know how to solve it. enter image description here

My code for the "REMOVE" button

 private void BtnQuitar_Click(object sender, EventArgs e)
  {
      foreach(DataGridViewRow item in DataGridViewSelectionArea.SelectedRows)
      {
          DataGridViewSelectionArea.RemoveAt(item.Index);

      }

    }
c#

1 Answers

  1. Best Answer

    If you bound the DataGridViewto a origen de datos, you can't remove items directly in the control, you have to remove the row from the DataTable and rebind for it to update

    On the other hand, if you define an Id column, it should be unique for each item, there I see that you have a 1 as Test and the same 1 for Bar, if it is Id it cannot be duplicated, otherwise it ceases to be Id If you want to use them SelectedRowsinstead of the checks you could search by id, but this must be unique, then you would do:

    private void BtnQuitar_Click(object sender, EventArgs e)
{
    if(DataGridViewSelectionArea.SelectedRows == null)
    {
       MessageBox.Show("Debe seleccionar un fila del grid");
       return;
    }

    var dt = (DataTable)DataGridViewSelectionArea.DataSource;

    foreach(DataGridViewRow item in DataGridViewSelectionArea.SelectedRows)
    {
        var row = dt.AsEnumerable().FirstOrDefault(r=> r["Id"] == item.Cells["Id"].Value);

        if(row != null)
        {
            dt.Rows.Remove(row);
        }
    }

    DataGridViewSelectionArea.DataSource = dt;

}

    the idea is to search in the data that you linked to the Grid to eliminate these and in the end show them again

    • 0