Help!

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

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

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 City,State,Country, then apply a sort to Country, then State, then City.