DataGridView.Rows.RemoveAt(int index) doesn't remove row in windows form?

Question

int i = dataGridView1.CurrentRow.Index;
dataGridView1.Rows.RemoveAt(i);

The above code for deleting current selected row (only allow to select 1 row) but I still can see the row remains in datagridview. Did I miss an update or invalidate ?

ps: dataGridView1 is data-bound.

ps2: I use linq query to bind data and I don't want to query again for just to show a row was deleted, I think it will slow down performance.

I resolved it from reading this : http://stackoverflow.com/questions/207901/datagridview-question Thank for all of your suggestion. — JatSing, Sep 23 '11 at 02:54

CharithJ · Answer 1 · 2011-09-22T02:05:06.040

2

I think the solution depends on how you bind the data. If you are binding a BindingList, RemoveAt() method removes handles everything for you and you don't have to refresh the DataGridView.

Try below and see...

dataGridView1.Refresh();

OR re-bind the data and see..

dataGridView1.DataSource = myDataSource;
dataGridView1.Refresh();

edited Sep 22 '11 at 02:05

answered Sep 22 '11 at 01:57

CharithJ

46,289
20
116
131

I tried dgv.Refresh(); and dgv.Parent.Refresh(); but it doesn't help – JatSing Sep 22 '11 at 01:59
@Sun: Can you show how you bind data? – CharithJ Sep 22 '11 at 02:01
dataGridView1.DataSource = myDataSource; and see... – CharithJ Sep 22 '11 at 02:05
I use linq query to bind data and I don't want to query again for just to show a row was deleted, I think it will slow down performance. – JatSing Sep 22 '11 at 02:09
Why cannot you delete it from the datasouce and refresh the dataGridView? – CharithJ Sep 22 '11 at 02:10
Try dataGridView1.ResetBindings() and see – CharithJ Sep 22 '11 at 02:17
dataGridView1.ResetBindings() doesn't work either – JatSing Sep 22 '11 at 02:25
May be something with AcceptChanges ? I am not sure... http://msdn.microsoft.com/en-us/library/system.data.dataset.acceptchanges.aspx – CharithJ Sep 22 '11 at 02:29
You need to change the DataGridViews SelectionMode in its properties from the default RowHeaderSelect to FullRowSelect, then it should work. – JeffS Apr 18 '18 at 19:44

unruledboy · Answer 2 · 2011-09-22T02:12:16.893

2

remove the item from the datasource, and bind again.

since the data comes from linq, before binding, you can do:

var result = fooLinq.ToList();
dataGridView1.DataSource = result;


//to remove and bind again
var result = dataGridView1.DataSource as List<FooType>;
result.RemoveAt(fooIndex);
dataGridView1.DataSource = result;

edited Sep 22 '11 at 02:12

answered Sep 22 '11 at 02:01

unruledboy

2,455
2
23
30

I use linq query to bind data and I don't want to query again for just to show a row was deleted, I think it will slow down performance. – JatSing Sep 22 '11 at 02:09
you do not need to query again, I made more detail info – unruledboy Sep 22 '11 at 02:12
1

...FooType is your actual biz type that return from your linq... – unruledboy Sep 22 '11 at 13:48

score 2 · Answer 3 · answered Sep 22 '11 at 02:45

If I understand you correctly, you want to delete rows selected by a user from your DGV.

Use the DataGridViewRowCollection of your DGV rather than the DataRowCollection of the DataTable. The DataGridViewRow has the Selected property that indicates whether a row is selected or otherwise.
Once you have determined that a row is to be deleted, you can use the Remove method of the DataGridViewRowCollection to delete the item from the grid, e.g. YerDataGridView.Rows.Remove(row)
Note that at this point, although the item is removed from the DGV, it still has not been deleted from the Access DB. You need to call the TableAdapter Update method on your DataSet/DataTable to commit the deletions to the DB, e.g. YerTableAdapter.Update(YerDataSet)

I normally would call Update once to commit the changes only after having removed all the items to be deleted from the DGV.

Yes, I understand the item isn't deleted from DB when I use this method — JatSing, Sep 22 '11 at 02:56

DataGridView.Rows.RemoveAt(int index) doesn't remove row in windows form?

3 Answers3

Linked