Roland Deschain
Roland Deschain

Reputation: 709

C# Datagridview does not sort Checkbox column

When I bind a Linq-to-sql query to a datagridview (using a BindingSource in between), the columns are sortable by default. However, this does not seem to be the case for boolean types. For these the datagridview uses Checkbox columns, but when I click on the header nothing happens. Solution anyone?

Upvotes: 16

Views: 7452

Answers (2)

David Reich
David Reich

Reputation: 779

In VS2012 in the designer you can also set the SortMode.

Right-click on the DataGridView and go to "Edit Columns".

There's a drop-down for SortMode with a choice of NotSortable, Automatic, and Programmatic.

It appears that the default for most columns is Automatic, but for checkboxes (boolean) columns the default is NotSortable.

Upvotes: 27

robertk
robertk

Reputation: 101

will this help?

dgv1.Columns["Colname"].SortMode = DataGridViewColumnSortMode.Automatic;

Upvotes: 10

Related Questions