This is my first c# application so I'm still figuring things out.
Ok here is my setup,
I have a MySqlDataAdapter filling a Dataset
The Dataset acts as the DataSource for a BindingSource
The BindingSource acts as the DataSource for a DataGridView
The DataGridView successfully displays the data! The data is a database of students at a martial arts school.
One of the columns is called "Belt Rank", I set this column up ahead of time to be a DataGridViewComboBoxColumn meaning it can take on any one of a predefined set of values, in this case the student's belt rank.
The values of this column can be:
White, Yellow, Green, Blue, Brown, Red, Black
What I want is to be able to sort the column by rank, rather then alphabetically.
I have searched the internet and have found no clear answer.
I know that DataGridView sorting is severely gimped by having a DataSource, however I dont know how to get around this.
I would greatly appreciate a clear explanation of how this can be achieved, or atleast a point in the direction of an explanation that wont make my head go "AHHHHHHHH!"
Thanks in advance!