I have a datagrid that is based on a dataset. I can access the data in code with the datagrid.item( row, column) function, but I have one problem : the user can select the order of the columns himself, so the columnnumber doesn't always have the same data. He can also sort the datagrid by clicking on the header.
So I would like to get the rownumber in the dataset that corresponds to the rownumber in the datagrid, so I can access data through a row:
dim localrow as mydataset.myrow
localrow = mydataset.myrow(..)
string = localrow.field
No what I don't figure out is how to assign the correct row. Can you help me ?