Hi Charlie,
Please refer to the following forum threads that will help you to get the sorted order.
http://www.syncfusion.com/Support/Forums/message.aspx?MessageID=36183See the last thread in this forum.
http://www.syncfusion.com/Support/Forums/message.aspx?MessageID=12261Using these information you can reapply the same sorting, programmatically after changing the datasource.
Here is the code snippet to apply sorting programmatically.
CurrencyManager cm = this.gridDataBoundGrid1.BindingContext[this.gridDataBoundGrid1.DataSource,
this.gridDataBoundGrid1.DataMember] as CurrencyManager;
if(cm != null)
{
int colIndex = this.gridDataBoundGrid1.Binder.ColIndexToField(2);
string colName = this.gridDataBoundGrid1.Binder.InternalColumns[colIndex].MappingName;
DataView dv = cm.List as DataView;
dv.Sort = string.Format("[{0}] DESC", colName);
}
}
Best Regards,
Saravanan