DataCollection | ComponentOne
Work with DataCollection / Sorting
In This Topic
    Sorting
    In This Topic

    DataCollection implements the ISupportSorting interface to support sorting data in ascending and descending order. It enables you to sort data according to the specified sort path and direction using SortAsync method of the IDataCollection class. DataCollection also allows you to set the direction of sort operation using Direction property of the SortDescription class which accepts values from the SortDirection enumeration. Moreover, it allows you to specify the path of a data item to which the sort operation needs to be applied using the SortPath property of SortDescription class.

    IDataCollection provides three overloads of SortAsync method. Refer this topic to know more about the overloads. In the example, we have used SortAsync<T>(this C1.DataCollection.IDataCollection<T> dataCollection, string sortPath, [C1.DataCollection.SortDirection sortDirection = 0]) method overload that uses data collection, sortPath and sortDirection as the parameters, where sortPath is the path of the data item to which the sort description is applied, and sortDirection is the direction of the sort operation.

    The GIF shows sorting the data in the data grid by 'Name' in the ascending order using the SortDirection enumeration.

    The image shows sorting in an application.

    The following code demonstrates the implementation of the SortAsync method to sort data in DataGridView. In this example, the Name column of DataGridView is sorted alphabetically in ascending order. This example uses the sample created in the Quick Start section.

    This is the C# code for sorting in WinForms application:  

    C#
    Copy Code 
    // Sort data using SortAsync method
private async void btn_Sort_Click(object sender, EventArgs e)
{
    if (cv != null)
    {
        await cv.SortAsync("Name", SortDirection.Ascending);
    }

}

    This is the VB code for sorting in WinForms application:

    VB
    Copy Code 
    ' Sort using SortAsync method
Private Async Sub btn_Sort_Click(sender As Object, e As EventArgs) Handles btn_Sort.Click

    If cv IsNot Nothing Then

        Await cv.SortAsync("Name", SortDirection.Ascending)

    End If

End Sub

    This is the C# code for sorting in WPF application:

    C#
    Copy Code 
    // Sort using SortAsync method
private async void btn_sort_Click(object sender, RoutedEventArgs e)
{
    if (cv != null)
    {
        await cv.SortAsync("Name", SortDirection.Ascending);
    }
}

    This is the VB code for sorting in WPF application:

    VB
    Copy Code 
    ' Sort using SortAsync method
Private Async Function Btn_Sort_ClickAsync(sender As Object, e As RoutedEventArgs) As Task Handles btn_Sort.Click
    cv = New C1DataCollection(Of Customer)(Customer.GetCustomerList(100))
    grid.ItemsSource = cv
    Await cv.SortAsync("Name", SortDirection.Ascending)
End Function

    This is the code snippet for sorting in Xamarin Forms application:

    Xamarin Forms
    Copy Code 
    var datacol = Customer.GetCustomerList(10);
C1DataCollection<Customer> dc = new C1DataCollection<Customer>(datacol);
var sort = dc.SortDescriptions.FirstOrDefault(sd => sd.SortPath == "Name");
var direction = sort != null ? sort.Direction : SortDirection.Descending;
dc.SortAsync(x => x.Name, direction == SortDirection.Ascending ? SortDirection.Descending : SortDirection.Ascending);
FlexGrid _grid = new FlexGrid();
grid.ItemsSource = dc;
grid.VerticalOptions = LayoutOptions.FillAndExpand;

    This is the code snippet for sorting in Android application:

    Android
    Copy Code 
    FlexGrid grid = (FlexGrid)FindViewById(Resource.Id.Grid);
var data = Customer.GetCustomerList(250);

 C1SortDataCollection<Customer> sdc = new C1SortDataCollection<Customer>(data);

 var sort = sdc.SortDescriptions.FirstOrDefault(sd => sd.SortPath == "Name");
 var direction = sort != null ? sort.Direction : SortDirection.Descending;
 sdc.SortAsync("Name", direction == SortDirection.Ascending ? SortDirection.Descending : SortDirection.Ascending);
 grid.ItemsSource = sdc;

 grid.SelectionMode = GridSelectionMode.Cell;

 grid.AllowSorting = false;
 grid.ShowMarquee = true;
 grid.AutoSizeColumns(0, grid.Columns.Count - 1);
 grid.RowHeaders.Columns.Clear();

    This is the code snippet for sorting in iOS application:

    iOS
    Copy Code 
    grid = new FlexGrid();
var data = Customer.GetCustomerList(100);
datacol = new C1SortDataCollection<Customer>(data);
var sort = datacol.SortDescriptions.FirstOrDefault(sd => sd.SortPath == "Name");
var direction = sort != null ? sort.Direction : SortDirection.Descending;
datacol.SortAsync("Name", direction == SortDirection.Ascending ? SortDirection.Descending : SortDirection.Ascending);
grid.ItemsSource = datacol;
grid.SelectionMode = GridSelectionMode.Cell;
grid.RowHeaders.Columns.Clear();
var _navbarHeight = this.NavigationController.NavigationBar.Frame.Height + UIApplication.SharedApplication.StatusBarFrame.Height;
grid.Frame = new CGRect(this.View.Frame.X, this.View.Frame.Y + _navbarHeight, this.View.Frame.Width, this.View.Frame.Height - _navbarHeight);
this.View.AddSubview(grid);