We have used sorting in the ASPOSE grid and its work perfectly.
And we are saving grid data by following way.
Step 1) First we are checking which cell is updated and we are keeping record of row and column no. of updated cell using client side onCellUpdated(cell) function.
Step 2) On click of save button we are taking dataset from Grid datasource and then we are passing row and column no. to dataset and fetching the updated cell data and then we are saving into data base.
Upto this point everything works perfectly but if we sort any column and then update any cell, then if we follow above 2 steps we are not getting the actual updated cell's row and column number. So from dataset we are getting wrong value because of wrong row and column number.
In short I think when we are sorting any column, sorting happening only on sheet and not on grid dataset.
Please advice solution for this. So that we will get proper row and column number after sorting OR on sorting of column number, we should get sorted dataset.
Thanks and Regards
Prasad . G . Godbole