title: C#: Sorting on date field in a Winforms app
body: <p>In an sqlite database I have a date field stored as a TEXT property with the following format:</p>
  
  <pre><code>dd/mm/yyyy hh:mm:ss
  </code></pre>
  
  <p>(e.g., the text in the field looks like: 28/04/2009 19:15:17)</p>
  
  <p>I have bound a DataGridView to the database via the GUI in VS2008. So basically all the code was automatically generated for me. When I start my app it reads the database and displays all the rows in the DataGridView. I can sort on all columns except the date column. I suspect this is because the DataGridView thinks the date column is just plain text. How do I get this to work as I want it to?</p>
  
  <p><strong>UPDATE</strong></p>
  
  <p>As far as I am aware there is no DATE type in sqlite so I have to store as TEXT. Happy to be told otherwise though.</p>
  
  <p><strong>UPDATE</strong>
  The user would like to see the date in dd/mm/yyyy format.</p>
  
  <p>Thank you.</p>