Your code worked for multi column sorting, however the sort order of the columns is messed up.

For example if i click on the "First Name" column first and then the "Last name". The grid sorts by the last Name and then the First Name.

Is there any way to do it so that the grid sort in the order it is clicked. In this example: The sort on the "first name" should remain and then it should sort by "last name".

Thanks,

Thanks for the code, that helped.

        private void ultraGrid1_BeforeSortChange(object sender, BeforeSortChangeEventArgs e)
        {
            // Loop through the existing sorted columns. 
            foreach (UltraGridColumn column in e.Band.SortedColumns)
            {
                SortIndicator originalSortIndicator = column.SortIndicator;
                switch (originalSortIndicator)
                {
                    case SortIndicator.Disabled:                        
                    case SortIndicator.None:
                        // If the column was not already sorted, leave it alone. 
                        break;
                    case SortIndicator.Ascending:
                    case SortIndicator.Descending:
                        SortIndicator newSortIndicator = e.SortedColumns.Exists(column.Key)
                            ? e.SortedColumns[column.Key].SortIndicator
                            : SortIndicator.None;

                        // If the column was sorted, see what it's new state is. 
                        switch (newSortIndicator)
                        {
                            case SortIndicator.None:
                                // This column went from sorted to unsorted. So keep it sorted. 
                                e.SortedColumns.Add(column, originalSortIndicator == SortIndicator.Descending);
                                break;
                            case SortIndicator.Disabled:
                                // This should never happen since the user cannot sort a disabled column. 
                                break;
                            case SortIndicator.Descending:
                            case SortIndicator.Ascending:
                                // This column was sorted and is still sorted (although the 
                                // direction may have changed), so leave it alone. 
                                break;
                        }
                        break;

                }
            }
        }

Hi,

I am facing the same problem, can you please provide a sample code for "handling the BeforeSortChanged event".

I have a seperate button to clear the sort  on the columns. Any help appreciated.