DataGrid "logical" row from HitTest

[ABean]

Guys, On the datagrid when you do a HitTest you get the "physical" row that the mouse is over. If the user has sorted the grid (by clicking on one of the column headers) and changed the order of the rows is there a way to get the "logical" row from the "physical" row? Thanks

[Heath Stewart]

Get the DataView used to sort the data. If you bound your DataGrid to a DataView, you're already done. If not, get the DataTable you're binding to (whether it's the DataSource or it's name is the DataMember) and get the DefaultView property.

Microsoft MVP, Visual C# My Articles

[ABean]

Thanks Heath, I'm binding to a DataTable. I've looked at the DefaultView property as well as the other properties of the DataTable but I am unsure how to translate the HitTest Row number from the DataGrid into a row number of the DataTable. I need to get the DataTable row number integer not to update the actual row in the control but to update an associated array. (DataTable row number is the index into the array.) I looked at the Find property but the rows displayed in the table are not unique. It this translation possible?

[ABean]

I did some more reading and it looks like I need to put a primary key column on my table - and then I guess I will hide it. But even if I add the primary key column how do I resolve the HitTest Row number from the DataGrid into a DataTable row number?

[Heath Stewart]

IIRC, you should be able to get it using DataView[physicalRowIndex]. This gets you a DataRowView. Get the Row property to get the actual DataRow, though if you just want the value of a column in the row, you can get it as you would with a DataRow using the DataRowView.

Microsoft MVP, Visual C# My Articles