How to Sync ColumnOrder between UltraGrid and UltraGridColumnChooser

125

Mohammad posted over 15 years ago

Hi, I have a UltraGrid (Winforms) and I have allowed moving of the columns. This means a user can move the column 3 to position column 2 and so on. The user can also select which columns to see using the UltraGridColumnChooser control. Is there any way that I can persist the column order so that when the user starts the application again then the column order is same as he/she left the last time. OR How can I access the most updated column order? Why does the UltraGridColumnChooser not sync with Grid when I move the columns around? Thanks,

469350

Offline Mike Saltzman posted over 11 years ago in reply to felix

Hi,

There's no way to separate the sorting from the column order. But you could load the layout and then remove the grouping and sorting.

// Load the layout
this.ultraGrid1.DisplayLayout.LoadFromXml(filename, propertyCategories);

// Clear all sorting and grouping
this.ultraGrid1.DisplayLayout.Bands[0].SortedColumns.Clear();
Cancel
Reply

Cancel
680

felix posted over 11 years ago in reply to Mohammad

Hello,

We just want to save/load the following :

1, visible columns (by the UltraGridColumnChooser)
2, columns display sequence/order (by draging)

The group by columns should not be saved/reloaded.

Is it possbile to fulfill it? Any code demo will be appreciated.

Thanks
Cancel
Reply

Cancel
125

Mohammad posted over 15 years ago in reply to Matt Snyder

Thanks Matt, Yes, I am using DisplayLayout.SaveAsXML and DisplayLayout.LoadFromXML methods and they are working out great! Thanks for all the help!
Cancel
Reply

Cancel
37774

Matt Snyder posted over 15 years ago

You can save and load the layout of the grid through the DisplayLayout.Save (or SaveAsXml) and DisplayLayout.Load (or LoadFromXml) methods; these will take into account the column positions that the user has specified.
As for the issue with the column order, that seems to be a bug since it's not updated even when the ColumnDisplayOrder is set to SameAsGrid. You should report this to Developer Support. A quick hack workaround would be to listen to the grid's AfterColPosChanged event and force the column choose to refresh, i.e.:
private void ultraGrid1_AfterColPosChanged(object sender, Infragistics.Win.UltraWinGrid.AfterColPosChangedEventArgs e)
{
    if (e.PosChanged == Infragistics.Win.UltraWinGrid.PosChanged.Moved)
    {
        this.ultraGridColumnChooser1.ResetColumnDisplayOrder();
        this.ultraGridColumnChooser1.ColumnDisplayOrder = Infragistics.Win.UltraWinGrid.ColumnDisplayOrder.SameAsGrid;
    }
}
-Matt
Cancel
Reply

Cancel