IsAutoFilterEnabled is not supported when ItemsSource is a DataTable type

[jebissey]

In a very simple code, I noticed that ListCollectionView is supported as ItemsSource but not DataTable.

[tom-englert]

Duplicate of #1
DataGrid only supports sort and filter if the source implements IList, but DataTable doesn't.

[jebissey]

Thank for your response.
So I use now DataView type. This one implement IList.
In xaml view no problem was reported just after changing type.

But during execution I got

And now we have the same problem again

[tom-englert]

Maybe because DataView is also IBindingList, CollectionViewSource.GetDefaultView(Object) returns a non-sortable CollectionView?

[tom-englert]

Try to explicit create a ListCollectionView

[jebissey]

That is my main issue.
The DataTable is builded by generic way. As result we have x rows with y columns.
I looked up a lot, but I didn't find a solution to transform it as a anonymous typed list.

[tom-englert]

Maybe #100 is helpful?

[jebissey]

Thank again.
Actually, I still have the same problem, because I don't know the column name at compile time.
I need to find a way to make the red underlined line work in this code.

[tom-englert]

Just use the exact code as in #100, don't drop the essential cast

[tom-englert]

If every row is already a dictionary, you can also use a binding to ["columName"]

[tom-englert]

See e.g. https://github.com/dotnet/ResXResourceManager

[jebissey]

I know your program, and I use it in VS.
Thanks for this :-)

Sorry for the delay, but I'm currently working on 3 programs, and I have to change depending on the availability of colleagues...

This is the content of my data

So I wonder how to transform it to an object usable with DataGridFilter.IsAutoFilterEnabled="True"

[tom-englert]

Maybe better try e g. on stack overflow, as this out of scope of this project

[jebissey]

it's done
https://stackoverflow.com/questions/76580580/how-to-transform-listdictionnarystring-string-to-observablecollectionobjec

[jebissey]

Actually an ObservableCollection is not a good solution because the name of the column isn't the exact name of the properties.
My DataBase generic structure looks like this one
https://stackoverflow.com/questions/23687426/dynamically-pivot-in-linq-pivoted-columns-determined-at-runtime

So I wondering if there is a way to know which is the method that is not supported by the PresentationFramework?