I want to do a lot of things like sorting, paging, grouping and filtering on the WPF Datagrid.
As I already know, paging could be done using LINQ, but firstly, I need to get the total number of records retrieved from the database,
and then page the records in another ObservableCollection class, bind to the WPF Datagrid so that it can display only those paged records.
Sorting, Grouping and Filtering also can be done using CollectionView class.
The problem is, how can I do to sort a paged DataGrid ? Let says I have 100 records, 20 per page, total 5 pages
after binding 20 records to the Datagrid, I can only sort those 20 records ONLY when I clicking the header button of DataGrid ...
What I want to do is when I click on the header button of the DataGrid, I can sort the total 100 records again and then get only 20 out of them, display it.
Does anyone can give me a hand and tell me how can I achieve this ?
By the way, I know PagedCollectionView is available on Silverlight 3 but absent in WPF Application, can I use this function on WPF Application ?
Thanks for reply !!!