Reputation: 709
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
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
Reputation: 101
will this help?
dgv1.Columns["Colname"].SortMode = DataGridViewColumnSortMode.Automatic;
Upvotes: 10