Colulmn sort criteria is reverting back on Save click in WPF

Question

4.00/5 (1 vote)

See more:

Hi All

We have datagrid binded with list of object. User can perform sorting on column in it which is persisted to database to retieve new sortdescription back and bind with grid in new session.

But on clicking on Save button the grid is reverting the column sorting from the data and there is no effect on sortdescription saved in database. Hence modified sortdescription is not retrieved in sucessive sessions too.

Please suggest.My datagrid is as shown below :-

XAML

CanUserReorderColumns="True" CanUserResizeColumns="True" CanUserResizeRows="True"
CanUserSortColumns="True" AutoGenerateColumns="False" Margin="0,0,0,41"
ItemsSource="{Binding View}" Sorting="_dataGrid1_Sorting">

Code written for Save click is as shown below where GetRequiredSortData is retrieving previous sortcriteria for all column from database of tab being clicked.

C#

Private void SaveButton_Click(object sender, RoutedEventArgs e)
{
model.Save();

sdRequired = GetRequiredSortData(); 
_dataGrid1.Items.SortDescriptions.Clear();
_dataGrid1.Items.SortDescriptions.Add(new SortDescription("GroupExpandStatus",
ListSortDirection.Descending));
_dataGrid1.Items.Refresh();
ListSortDirection sortDiection;

if (sdRequired != null)
{
sortDiection = ListSortDirection.Descending;
if (sdRequired.SortOrder)
sortDiection = ListSortDirection.Ascending;
_dataGrid1.Items.SortDescriptions.Add(new SortDescription(sdRequired.SortColumn,
sortDiection));
_dataGrid1.Items.Refresh();
} }

Now problem is when we dont do anything and click save nothing changes and column remains sorted but when any column is modified and then save is clicked in that case all user modified or retrieved sorting get undone. Row shuffles to random. Please suggest.

Posted 28-Aug-12 22:51pm

mynkmitl

Updated 11-Sep-12 2:12am

Kenneth Haugland

v3

Add a Solution

Comments

Thomas Duwe 29-Aug-12 6:08am

You have to be a little more specific.

What datagrid are you using?
How is the list of data bound to the grid?
What's happening in your save method?

Some code would be really helpful, otherwise nobody can help you.

Kenneth Haugland 11-Sep-12 8:15am

Use have a comment or question when you have some comments to an individual, and use imnprove question when you have additional information or updated code. The solution is for solutions only.

3 solutions

Solution 2

The Microsoft documentation is pretty specific on what to implement here:
http://msdn.microsoft.com/en-us/library/0868ft3z.aspx[^]

Posted 11-Sep-12 2:14am

Kenneth Haugland

Solution 3

Actually sortingdescription added to my listviewcollection binded with itemsource of grid was getting undone when was getting assigned to grid so I applied my sortdescriptions after binding same to grid and things got done. :)
Thanks.

Posted 17-Sep-12 2:04am

mynkmitl

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

mynkmitl · Accepted Answer · 2012-09-17T02:07:00

I was binding my list to grid in async method but was applying sorting in normal flow to grid so there were sync issues. therefore i applied sortingdescriptions in async method only after the list get binded to grid. So once grid is fully assigned data from list sortingdescription get added to it. This resolved my issue.
Thanks.