Sort one column in a datagridview based on another columns values

[Debra has a question]

I have a datagridview that loads up all the columns - Item, Description, Price - the price column is not a decimal because if this customer for whatever reason has a special price then it says the special price\regular price if not it just says the regular price so I made this column into an nvarchar. I want though, to be able to sort the price column decimal wise not like a string. I was wondering if there is a way to sort the price column like a different column. I have the list of all the prices without the \ in an invisible column in the datagridview. I was wondering if when I sort the price column it can sort it based on the column that has the list of all the prices without the \. Like some sort of custom sort?
Debra has a question

Continue reading...