Sort Query Results in a DataGrid

TedChapin

I am using a QueryTask to get records from a geodatabase table (not a feature class).  I want to show the results in a DataGrid.  The binding is easy enough: DataGrid1.ItemsSource = e.FeatureSet.Features.  But how can I sort the results?  I can make the data grid columns user sortable, but I want the grid to be sorted the first time they see it.  I tried converting the query results to a ObservableCollection and using a PagedCollectionView's SortDescriptions, but I don't know what the PropertyName is for the SortDescription.  I tried "Attributes(fieldname)" but it doesn't sort.

Thanks for any help,

Ted Chapin

TerryGiles

You could sort the feature set before binding it.  I've used the code below to sort the featureset returned by a query task

        void QueryTask_ExecuteCompleted(object sender, QueryEventArgs e)
        {

            FeatureSet fs = e.FeatureSet;
            if (fs.Count() == 0)
            {
                MessageBox.Show("Sorry, no data matches your query.  Please try again", "Query", MessageBoxButton.OK);
            }
            else
            {
                FeatureSet fsSort = new FeatureSet(fs.OrderBy(x => x.Attributes[fs.DisplayFieldName]));
                fsSort.DisplayFieldName = fs.DisplayFieldName;
                fsSort.GlobalIdFieldName = fs.GlobalIdFieldName;
                fsSort.ObjectIdFieldName = fs.ObjectIdFieldName;

                ... do whatever with fsSort ...............

EDIT:
If you use the code above, you will do not get the FieldAliases in the new fsSort.  The FieldAliases property on the FeatureSet is ready only so if you need the aliases you might try another method like this -

                IList<Graphic> gsort = fs.Features.OrderBy(x => x.Attributes[fs.DisplayFieldName]).ToList();                
                fs.Features.Clear();
                foreach (var g in gsort)
                {
                    fs.Features.Add(g);
                }

                ... do whatever with fs, which still has valid FieldAliases ......