Datagrid sorting problem

Question

I've got a treeview and a datagrid and depending on which tree node you select the contents of my datagrid changes. Grid update is done as follows: DataSet AppsDS = // comes from a stored proc MyDataGrid.SetDataBinding(AppsDSTable); MyDataGrid.TableStyles.Clear(); DataGridTableStyle ts = new DataGridTableStyle(); ts.MappingName = this.MyDataGrid.DataMember; MyDataGrid.TableStyles.Add(ts); // Hide the desired columns.. MyDataGrid.TableStyles[0].GridColumnStyles[ProductId].Width = 0; Thats how I populate my grid but I've noticed that if I re-order the grid by clicking on a column-header then when I attempt to process the selected row it picks up the wrong row. E.g This is how I process which row is highlighted when the datagrid is doubleclicked: DataSet tmpDS = (DataSet)this.MyDataGrid.DataSource; object ProdId = tmpDS.Tables[0].Rows[MyDataGrid.CurrentCell.RowNumber][ProductId]; I've noticed that the CurrentCell.RowNumber isnt correct IF I have re-ordered the grid's contents by clikcing on column headers. Any ideas how to fix this problem since I dont really want to disable column sorting.

Bloopy · Answer

Never mind the solution for the selected rows is to point the current row index at each one. Then you can get all the selected rows in a loop.

Bloopy · Answer

I found the same problem with DataGrids. Thanks to geo I can now correctly get the current row. However what if you are in the same situation except multiple rows are selected and you want to get them all? I think I might have to create an extra column which holds the index of the correct row in the DataView behind.

eksypnos123 · Answer

to get the current row when you have the table sorted by clicking on a column you have to use: DataRow dr = ((DataRowView)bindingManager.Current).Row;