Anyone experienced with the WPF DataGrid?

bremen1874 · 12 Oct 2015 at 00:33

I'm just getting started with WPF (C# .Net 4.5.1).

I'm using the standard WPF DataGrid control in a few places and setting the ItemsSource in the code behind to a Linq to SQL query.

It's all working as I want except that when I update the ItemsSource I loose any user applied column sorts.

Is there a simple way to persist the sort information when the ItemsSource is updated? At this point I don't really care how its implemented; it's something I can comeback to at a later date if I need to.

I thought It'd be an easy Google search but seems not.

RobHu · 13 Oct 2015 at 12:57

It's probably because you're reinitialising the ItemsSource each time you run the query. You need to look into using a data bound ObservableCollection to hold your data.

Take a look at this (you may not need the ObservableCollectionView stuff though):

http://stackoverflow.com/questions/11505283/re-sort-wpf-datagrid-after-bounded-data-has-changed

Also search for binding an ObservableCollection to a datagrid.

bremen1874 · 13 Oct 2015 at 18:45

That makes some sense; I'll do some more research and see if I can get it working.

Thanks for the advice.

dazzerd · 13 Oct 2015 at 21:10

IGNORE

Trucamo · 14 Oct 2015 at 13:42

Rather than setting the value for ItemsSource multiple times, set it once to an ObservableCollection, then Clear/AddRange your items to the backing collection.

bremen1874 · 14 Oct 2015 at 21:44

Thanks for the help. I think I've now got it working as I wanted using ObservableCollection; I now just need to test it properly.