Trials and Tribulations of DataGridView, Column Selections, and Sorting

I had to implement some custom sorting in a DataGridView recently.  Essentially, the stakeholders wanted full column selection (like Excel) while still having the ability to sort the data based on a particular column.

This particular DataGridView is data-bound.  DataGridView offers the Sort(DataGridViewColumn, ListSortDirection) method to perform this.  Nice and easy I thought: I’ll set the SelectionMode to DataGridViewSelectionMode.ColumnHeaderSelect and simply call Sort with the selected column.

Well, much to my chagrin this had the side effect of making that column look selected all the time.  No matter where else I clicked, that recently sorted column looked selected (SelectedColumns had a count of zero).  And to add insult to injury, when I control-clicked that column (thinking it was selected) to unselected it, it caused a NullReferenceException deep in the framework.

Suffice it to say, this makes it very difficult to sort by columns in DataGridView without using the built-in sort-column-when-header-is-clicked mode.

What I’m now attempting to do is to unselect the column before sorting it.  This, in itself, is not trivial either; there’s no public method to select or deselect a column in the DataGridView.  I’ve had to create a new DataGridView derivative and call the protected method SetSelectedColumnCore.  A few hoops…

I’ve logged a couple of issues on Microsoft Connect about these problems.  The first is about ctrl-clicking the column and getting an exception: The second is about the visual state of the column remaining “selected”: Attached to this post you will find the project referenced by the two Connect issues.

[Update: I’ve currently only tried this with a .NET 2.0 project in Visual Studio 2008 SP1; if you find this problem occurs in Visual 2008 RTM, please comment.]

[Update: I overlooked the DataGridViewColumn.Select property, so there’s no need to derive from DataGridView]

DotNetKicks Image

2 thoughts on “Trials and Tribulations of DataGridView, Column Selections, and Sorting

  1. I can’t believe I’m the only other person on the internet to ever encounter this. There’s no rhyme or reason to it, as far as I can tell, but if you run into this it happens every single time. Quite frustrating in fact.

  2. I tried this and it seemed to work:

    //Get the selected column
    DataGridViewColumn column = dataGridView.SelectedColumns[0];

    //Clear the selection dataGridView.ClearSelection();

    //Sort the column
    dataGridView.Sort(column, ListSortDirection.Descending);

    //Reselect the column
    dataGridView.Columns[column.Index].Selected = true;

Leave a Reply

Your email address will not be published. Required fields are marked *