How to retrieve the corect row in a data grid

[Joel Romain]

Hello everybody,

Or the documentation is a deep jungle, or I begin to be older for this kind of sport !!

I try a basic sample of a grid filled from a dataset. Then I try to retrieve the record displayed on the row I "Double click". The following code

RR = AllData1.TheRisks.Rows(.CurrentRowIndex)

works properly until .... I sort the grid

I've tried to retrieve data througth the currency manager :

myCurrencyManager = CType(Me.BindingContext(AllData1), CurrencyManager)
....
 RR = AllData1.TheRisks.Rows(myCurrencyManager.Position)

without Success. I suppose this basic problem has many solutions but I need only one. Please help