How can I sort a CollectionViewSource by a numeric string value.

Sat, 04 Jul 2009 15:49:15 Z

i have a collection view source which is populated with invoice items.

Each invoice item contains an invoice reference which is stored in the database as a varchar, although it is a numeric value.

I am using Linq to return my objects from the database and a converter to bind everything to the CVS. I need to sort by the invoice reference but it is sorting as string

(ie. 1, 100, 2, 200, 3, 300)

How can I apply a converter to the the sort parameter before if performs the sort?

How can I sort a CollectionViewSource by a numeric string value.

Sat, 04 Jul 2009 17:54:00 Z

You'd better convert the invoice number in the LINQ query, you can solve this in the CollectionView sorting.

http://weblogs.asp.net/marianor/

How can I sort a CollectionViewSource by a numeric string value.

Sat, 04 Jul 2009 18:14:17 Z

You'd better convert the invoice number in the LINQ query, you can solve this in the CollectionView sorting.
http://weblogs.asp.net/marianor/

Please Clarify....Did you mean to type "CAN'T solve this in the Collectionview sorting"?

As a workaround I have added an "InvoiceNumberInt" property to my Invoice. Perhaps this is the best way to do it in the long run. One of the things I like about the entity framework is that everything is a partial class so it makes is very easy to add methods and properties that I need.

Cheers.

How can I sort a CollectionViewSource by a numeric string value.

Sat, 04 Jul 2009 18:22:17 Z

SortDescription class only receives the name of the property and sort direction, there is not any way to add custom logic to apply a converter to order in a different way.

http://weblogs.asp.net/marianor/

How can I sort a CollectionViewSource by a numeric string value.

Sat, 04 Jul 2009 19:16:03 Z

Have a look at the CustomSort property, that is if your collectionview is a ListCollectionView:

http://msdn.microsoft.com/en-us/library/system.windows.data.listcollectionview.customsort.aspx