Persisting the sort order of the grid

[Administrator]

Hi Clay,

I''m looking for a way to persist the sort order of a GDBG. What kind of information do I have to persist/restore to get the last sort order of a grid?

Regards,
Thomas

[Administrator]

I forgot something:

I''ll get the same view for the user( sort direction in the header row ).

Regards,
Thomas

[Administrator]

Assuming you are using a DataTable as the DataSource, the simplest way is to get this information is through the DataView associated with the CurrencyManager.

CurrencyManager cm = (CurrencyManager)grid.BindingContext[grid.DataSource, grid.DataMember];
DataView dv = (DataView) cm.List;
//to persist the sort, save dv.Sort
string persistedValue = dv.List;
//to set the sort
dv.Sort = persistedValue;