user1112847 user1112847 - 1 year ago 94
C# Question

how to sort a datagridview by 2 columns

How do I sort a DataGridView by two columns (ascending)? I have two columns:


If I need to sort by one column, I do:

this.dataGridView1.Sort (this.dataGridView1.Columns["day"], ListSortDirection.Ascending);

But for two?

Answer Source

If your DataGridView is databound, you can sort your Datatable view and rebind to datatable as below:

private DataGridView dataGridView1 = new DataGridView();
private BindingSource bindingSource1 = new BindingSource();

private void Form1_Load(object sender, System.EventArgs e)
    // Bind the DataGridView to the BindingSource        
    dataGridView1.DataSource = bindingSource1;
    SortDataByMultiColumns(); //Sort the Data

private void SortDataByMultiColumns()
    DataView view = dataTable1.DefaultView;
    view.Sort = "day ASC, status DESC"; 
    bindingSource1.DataSource = view; //rebind the data source

OR, without using bindingsource and binding directly to DataView:

private void SortDataByMultiColumns()
    DataView view = ds.Tables[0].DefaultView;
    view.Sort = "day ASC, status DESC"; 
    dataGridView1.DataSource = view; //rebind the data source
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download