How to enable DataGridView sorting when user clicks on the column header?

by

Set all the column’s (which can be sortable by users) SortMode property to Automatic

dataGridView1.DataSource = students.Select(s => new { ID = s.StudentId, RUDE = s.RUDE, Nombre = s.Name, Apellidos = s.LastNameFather + " " + s.LastNameMother, Nacido = s.DateOfBirth })
                                   .OrderBy(s => s.Apellidos)
                                   .ToList();

    foreach(DataGridViewColumn column in dataGridView1.Columns)
    {
    
        column.SortMode = DataGridViewColumnSortMode.Automatic;
    }

Edit: As your datagridview is bound with a linq query, it will not be sorted. So please go through this [404 dead link, see next section] which explains how to create a sortable binding list and to then feed it as datasource to datagridview.

Code as recovered from dead link

Link from above is 404-dead. I recovered the code from the Internet Wayback Machine archive of the page.

public Form1()
{
    InitializeComponent();

    SortableBindingList<person> persons = new SortableBindingList<person>();
    persons.Add(new Person(1, "timvw", new DateTime(1980, 04, 30)));
    persons.Add(new Person(2, "John Doe", DateTime.Now));

    this.dataGridView1.AutoGenerateColumns = false;
    this.ColumnId.DataPropertyName = "Id";
    this.ColumnName.DataPropertyName = "Name";
    this.ColumnBirthday.DataPropertyName = "Birthday";
    this.dataGridView1.DataSource = persons;
}

More Related Contents:

  1. DataGridView Using SortableBindingList
  2. how to sort string as number in datagridview in winforms
  3. Sort dataGridView columns in C# ? (Windows Form)
  4. Filtering DataGridView without changing datasource
  5. How to handle click event in Button Column in Datagridview?
  6. List vs BindingList Advantages/DisAdvantages
  7. How to detect DataGridView CheckBox event change?
  8. how I can show the sum of in a datagridview column?
  9. how to bind datatable to datagridview in c#
  10. C# DataGridView Checkbox checked event
  11. DataGridView checkbox column – value and functionality
  12. How to sort databound DataGridView column?
  13. Show row number in row header of a DataGridView
  14. How to filter data using Entity Framework in a way that DataGridView be editable and context track changes?
  15. Search for value in DataGridView in a column
  16. Adding Text to DataGridView Row Header
  17. Show Loading animation during loading data in other thread
  18. Programmatically add new column to DataGridView
  19. How do I implement automatic sorting of DataGridView?
  20. Rows cannot be programmatically added to the datagridview’s row collection when the control is data-bound
  21. DataGridView with Button Control – Delete Row
  22. DataGridView AutoFit and Fill
  23. How do I change the datagridview selected row background color?
  24. Check/Uncheck a checkbox on datagridview
  25. Open dropdown(in a datagrid view) items on a single click
  26. Datagridview full row selection but get single cell value
  27. DataGridView bound to BindingList does not refresh when value changed
  28. How to move focus on next cell in a datagridview on Enter key press event
  29. How to display an image in a datagridview column header?
  30. DataGridView not showing properites of objects which implement ICustomTypeDescriptor

Leave a Comment