I have a little problem with how the gridsortingexample was coded in the C# version of the book (I suppose that the
VB example was coded with the same logic)
How the example works :
- the data is read from the DB server
- a dataview is created to establish the wanted sort and bound the to grid
- and then it comes :
each time the sort order is changed, this process is repeated.
My remark on this is : wouldn't it be better to keep the dataset and dataview (somewhere in memory) and simply change the sort of the dataview, without re-reading the data from the server ? If not why work with a dataview ? You can simply let the datasort by the db-server.