how to sort a listview on a different column than was clicked *RESOLVED*

I understand sorting on columns using the IComparer.
Can anyone tell me how to sort on a different column than was clicked.

Even though I searched the forums I did not find a specific answer to this one.

I have since sorted it out. You have to write a seperate class for each sort method which is basically each column.

if the data is pulled from a database would it be easier to simply re-query and use an ORDER BY clause?

I haven't fooled with the iCompare yet so I don't know if that difficult or not.

I thought is was hard but (like anything) it isn't that hard once you know.

My data isn't actually pulled from a database, its pulled from a number of text files.

Does anyone have this CODE for sorting by column clicked on a Listview in VB.NET ???
Thanks.