title: How to sort a DataGridView column (tied to a BindingSource) by date?
body: <p>I've got a DataGridView which, amongst others, has columns containing dates. Unfortunately, the dates are in the format DD.MM.YYYY and the whole value is in 1 column, which is the common date format here in Europe. The DGV is tied to a BindingSource which is capable of sorting and advanced sorting.</p>
  
  <p>The problem is the following: If I just use the standard sorting of the DGV, the dates are viewed as strings (they're displayed in a DataGridViewTextBoxColumn) and thus sorted by day->month->year but of course I'd want exactly the opposite; I want them sorted chronologically.</p>
  
  <p>So, is there a way to sort this columns the way I want them to?</p>
  
  <ul>
  <li>By far the easiest way would be to be able to use the SortCompare
  event of the DGV but apparently that can't be done if the DGV is tied
  to a DataSoruce.</li>
  <li>Of course I used Google and I always get the "use the Sort property for advanced sorting" solution. The BindingSource that's tied to the DGV indeed does support sorting and advanced sorting but as I understand it, this just gives me the possibility to e.g. sort by multiple columns and doesn't provide a way to make it sort the date column by year->month->day (or in more general terms allows me to implement a kind of compare function). Or am I missing something?</li>
  </ul>
  
  <p>What options do I have to achiev what I want? When explaining, please keep in mind that I'm -althoug not new to programming- new to this Windows Forms stuff.</p>
  
  <p>Thanks in advance!</p>