Guys,

I just switched out my code for sorting on a listview and used the built in capabilities, and suddenly my form takes 4 years to load as the LV control sorts every item over and over everytime there is an addition. Doh!

So, I switch off autocolumnsoft and zoom, done in 2 seconds. So, I am now doing an order by from my proc, but it orders on the second column of the listview, is there any chance of being able to set the column that the sort is done on when the lv control is first drawn?

thanks

Geoff.

Actually this sorting logic is being done by the standard .NET ListView. However, I am not sure why it woulc be firing like this as I have some massive lists that get loaded and I use this feature a lot and have not experienced this. So I would be curious as to what logic you have going on behind the scenes here. Not to say that there isn't something that could be done, but I have not experience this slowness as the sort doesn't fire until after the the Requery. The only other time it fires is when a column header is clicked...so there has to be something going on here.



Not that it will resolve this issue, but in the 1.7 release you will be able to see the new StrataListView which is a list written from scratch and has native sorting and supports native data types for true sorting. A sort value can be supplied to every column which doens't have to match the text displayed within the column. So you can truly sort dates, integers, strings, etc. With this logic you can even make check boxes (which are allowed in any column) or images (which are also allowed in any column) to be sortable.