Does anyone have any suggestion on how to make a listview sort quickly?
I loaded data from an Access db, and whenever I try to sort by clicking the Option Button, it takes a while.
Printable View
Does anyone have any suggestion on how to make a listview sort quickly?
I loaded data from an Access db, and whenever I try to sort by clicking the Option Button, it takes a while.
have you tried turning the listview property 'Sorted' to true?
I can't think of any other way than you order them in Database and then load...
Yes...Geespot, I have the Sorted property checked
Moin, will that make it sort faster?
Certainly it would.. but. then you could only order the things when you load them from table....so it would do bad rather than good.:rolleyes:
Is your listview multicolumn? and you want to sort on any column???????
I did something similar with a treeview. When I wanted to sort it, I just threw out all the information, did another call to the database and repopulated it. If you turn off window redraw first it helps with the speed.
Moin..I have 5 columns, and I would like to sort it on any column
Then do it the way I mentioned earlier.. Clear the listview send a command to database to order on your desired field and re-populate...
But I doubt about its usefulness