I've seen this question a few times on the web and so far no one has come up with a workable solution.
I'm using the sorting in ADG with an XMLListCollection bound as a dataprovider. The user's are not happy because if the data changes in the column that's being sorted, the list resorts. How can I remove the dynamic sorting but keep the order of the sort. We want it to work like Excel where you do a sort but when you change the data it doesn't reorder the list. What's the best, easiest way to do this? My guess would be that I want to make a copy of the XMLListCollection but somehow save it in sorted order, then swap the copy in for the other XMLListCollection. Not sure how to do that. Thanks for any help.