ok, let me be more clear.  I have a list of first and last names.

Last Name       First Name

Doe                    John

Doe                    Abe

The users want to sort by first name, then sort by last name.  So they click on first name then click on last name.  The problem is the first name reverts back to the original sort when last name is sorted.  Is there a way to do this without holding down shift?

There's nothing like that built-in to the grid.

You could probably handle the BeforeSortChanged event and examine the previous SortedColumns and the new one and then merge them rather than losing the original sort. But then how would the user ever turn sorting off?

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.

        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;

                }
            }
        }

Thanks for the code, that helped.

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,