I have several wpf DataGrids that use something similar to:
As a best concept for various ID fields in my database. This is great when needing to display editable data that is linked by ID, and my converter handles the validation and cleanup if needed. Otherwise an SQL View,
or Joined Table SQL would not be able to send updates directly to the database (DataSet Wizard). For this DataGrid's Contact column (bound to the ContactID field from a ICollectionView; bound to a DataSet.ClientsToContacts DataTable), I have
an underlying value of Integer, and a converted surface value of String. I want to sort on the string.
Using ICollectionView.View.SortDescription(path,direction) will only sort on the Integer, and I am desprately seeking work arounds.
View Complete Post