Remove row from DataSet if bound table is sorted

Question

I have a DataGridView that is bound to a DataSet and I allow someone to remove a row from the table and I remove the row from the set. My code looks like this:

ds.Tables(0).Rows(dgCourseList.SelectedRows(0).Index).Delete()

My problem I found is if the grid gets sorted the index of the rows no longer corresponds to the indexes in the DataSet. As a result the wrong rows get removed from the set.

Can I solve this problem with maybe having to sort the DataSet on some sort event of the DataGridView?

Answer 1

I think you'll want to use the CurrencyManager to handle this.

Here's a quick article explaining the concept: http://support.microsoft.com/kb/817247

' Get the Currency Manager by using the BindingContext of the DataGrid '
Dim cm As CurrencyManager = CType(Me.BindingContext(DataGrid1.DataSource, DataGrid1.DataMember), CurrencyManager)

' Retrieve the default DataView of the DataGrid '
Dim dv As DataView = CType(cm.List, DataView)

' Use Currency Manager and DataView to retrieve the Current Row '
Dim dr As DataRow
dr = dv.Item(cm.Position).Row

' Display the Current Row Data '
TextBox1.Text = dr(0).ToString
TextBox2.Text = dr(1).ToString

Using the CurrencyManager, you can retrieve the original state and go from there.

Cheers, JS

Answer 2

I haven't tested this but try the following assuming you have the DataKeys setup properly:

ds.Tables(0).Rows.Remove(ds.Tables(0).Rows.Find(dgCourseList.DataKeys(dg.SelectedIndex)))

EDIT: Based on you specifying that you are using a DataGridView which is a winforms app (I was assuming a webforms app) then you could try:

ds.Tables(0).Rows.Remove(ds.Tables(0).Rows.Find(DirectCast(dg.SelectedRows(0).DataBoundItem, DataRowView).Row))

EDIT 2: Updated because I think the cast was wrong... still untested though.