C#/Winforms: sorting a datagridview by a column that is not part of the DataSource

cdatagridviewdatasourcewinforms

I have a datagridview that has its datasource linked to a databinding from a database. All the columns are sortable by doubleclicking the header.

Now I added one extra column by hand that just contains numbers. Strangely I cannot sort the datagridview by this column. If I doubleclick the header nothing happens.

I have set sortmode to automatic.

What am I missing here?

Best Answer

This link should be the answer you need: Sorting an unbound column

Basically what you're trying to do is not supported. You have to handle the sorting yourself by keeping track of the direction and handle the sorting by using the SortGlyph.

Good luck, hope this helps.

Related Solutions

C# – Sort dataGridView columns in C# ? (Windows Form)

There's a method on the DataGridView called "Sort":

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

This will programmatically sort your datagridview.

.net – DataGridView sorting with nulls in DateTime column

An easy solution is to add a "tonull" function, which you run the e.cellvalue1 and 2 through each time a comparison is made. If the value is "" then the value of the cell will be changed to 01/01/1001 if you want null values to appear first on the sort or 01/01/3001 or something ridiculously high if you want them to appear last on the sort.

Private Sub dgvTable_SortCompare(ByVal sender As Object, ByVal e As DataGridViewSortCompareEventArgs) Handles dgvTable.SortCompare

    If e.Column.Index = 4 Then

        e.SortResult = System.DateTime.Compare(todatenull(e.CellValue1), todatenull(e.CellValue2))

    End If

    e.Handled = True
End Sub


Function todatenull(ByVal cellvalue)
    If cellvalue = "" Then
        Return "01/01/1001"
    Else
        Return cellvalue
    End If
End Function

Best Answer

Related Solutions

C# – Sort dataGridView columns in C# ? (Windows Form)

.net – DataGridView sorting with nulls in DateTime column

Related Topic