Help!

Question

How can I sort more than one column with GridControl?

turnipxiong · Answer

hi Thanks for your help! The control I used is not .Net DataGrid but GridControl of Syncfusion. I asked the same question to their supportwhich said it's impossible. Thanks again! Best Regards

Andrzej Wegierski · Answer

It's possible with some tricks (example for datatable/dataview): 1. Create Your own inherited DataGrid. 2. Create public property: [DesignerSerializationVisibility(DesignerSerializationVisibility.Hidden)Browsable(false)] public DataView View { get { try { return (DataView)(this.ListManager.List); } catch { return null; } } } 3. Set View.Sort property May be will be possible to get DataView from DataGrid using another method without inheriting

Adam Erstelle · Answer

Not sure if you can sort more then one column. There are a couple things you can try: 1) Add a sort to your select statement for the data being put into the GridControl 2) Apply individual sorts in reverse order to the grid control. eg: if you want sorted alphabetically CityStateCountry then apply a sort to Country then State then City.