Databases
StackOverflow2013
Postsdbo
POSort a DataGridView on multiple columns?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POSort a DataGridView on multiple columns?
    primarykey
    data
    text
    <p>I've searched for an example of sorting a DataGridView on multiple columns, but don't seem to be able to find an example which does what I would like.</p> <p>Basically, I have a bound DataGridView control (bound to a DataTable/DataView), and the bound DataTable has two columns:- priority and date. I would like to sort by date within priority. That is, the priority column takes precendence, then its the date but both can be ascending or descending.</p> <p>So, for example, I may have low priority, early date first <em>(order by priority asc, date asc)</em>, and, by clicking the date column header, switch to low priority, late date first <em>(order by priority asc, date desc)</em>. If I then click on the priority, I would like to have high priority first, then late date (the current sort order for the date column - <em>order by priority desc, date desc)</em>, but then be able to click the date column header to switch to high priority, early date <em>(order by priority desc, date asc)</em>.</p> <p>Ideally, I would like sort glyphs on both columns to show ascending or descending.</p> <p>Any ideas or pointers would be gratefully received.</p> <p>This (see below) seems to get pretty close, but the glyphs aren't working right.</p> <pre><code>using System; using System.Windows.Forms; namespace WindowsFormsApplication4 { public partial class Form1 : Form { DataSet1 dataset; public Form1() { InitializeComponent(); dataset = new DataSet1(); // two columns: Priority(Int32) and date (DateTime) dataset.DataTable1.AddDataTable1Row(1, DateTime.Parse("01-jan-10")); dataset.DataTable1.AddDataTable1Row(1, DateTime.Parse("02-jan-10")); dataset.DataTable1.AddDataTable1Row(1, DateTime.Parse("03-jan-10")); dataset.DataTable1.AddDataTable1Row(2, DateTime.Parse("04-jan-10")); dataset.DataTable1.AddDataTable1Row(2, DateTime.Parse("05-jan-10")); dataset.DataTable1.AddDataTable1Row(2, DateTime.Parse("06-jan-10")); dataset.DataTable1.AddDataTable1Row(3, DateTime.Parse("07-jan-10")); dataset.DataTable1.AddDataTable1Row(3, DateTime.Parse("08-jan-10")); dataset.DataTable1.AddDataTable1Row(3, DateTime.Parse("09-jan-10")); dataGridView1.DataSource = dataset.DataTable1.DefaultView; dataGridView1.AllowUserToAddRows = false; dataGridView1.Columns[0].SortMode = DataGridViewColumnSortMode.Programmatic; dataGridView1.Columns[1].SortMode = DataGridViewColumnSortMode.Programmatic; dataGridView1.Columns[0].HeaderCell.SortGlyphDirection = SortOrder.Ascending; dataGridView1.Columns[1].HeaderCell.SortGlyphDirection = SortOrder.Ascending; } private void dataGridView1_ColumnHeaderMouseClick(object sender, DataGridViewCellMouseEventArgs e) { DataGridViewColumn[] column = new[] { dataGridView1.Columns[0], dataGridView1.Columns[1] }; DataGridViewColumnHeaderCell headerCell = dataGridView1.Columns[e.ColumnIndex].HeaderCell; if (headerCell.SortGlyphDirection != SortOrder.Ascending) headerCell.SortGlyphDirection = SortOrder.Ascending; else headerCell.SortGlyphDirection = SortOrder.Descending; String sort = column[0].DataPropertyName + " " + fnSortDirection(column[0]) + ", " + column[1].DataPropertyName + " " + fnSortDirection(column[1]); dataset.DataTable1.DefaultView.Sort = sort; this.textBox1.Text = sort; } private String fnSortDirection(DataGridViewColumn column) { return column.HeaderCell.SortGlyphDirection != SortOrder.Descending ? "asc" : "desc"; } } } </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USBlack Light
    1. USBlack Light
    plurals
    1. This table or related slice is empty.
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POSort a DataGridView on multiple columns?
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POSort a DataGridView on multiple columns?
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POSort a DataGridView on multiple columns?
      1. This table or related slice is empty.
      1. VTUpMod
    1. COWhat do you mean by "aren't working right" with regards to the arrow glyphs? I really didn't want to take the time to write the sorting code, but I've gotten this to look right before, and it looks like you're most of the way there now.
      singulars
      1. POSort a DataGridView on multiple columns?
      1. USCody Gray
    2. COWell... the glyph for the first column (priority) toggles between up and down, but the glyph for the second column seems to be some kind of three-state, and displays as up, nothing, nothing. I'm guessing that the DGV doesn't really like having two sorting glyphs at the same time ? I've added a third column with "normal" sorting, and that seems fine but (with the glyphs on the first two columns disappearing), but clicking the header for the 2nd column then gives me a ascending glyph on the 1st column.
      singulars
      1. POSort a DataGridView on multiple columns?
      1. USBlack Light
    3. COGoogle for `MultisortDataGridView` IIRC.
      singulars
      1. POSort a DataGridView on multiple columns?
      1. USleppie
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload