title: Sorting dates in DataGridView
body: <p>I'm pulling different info from a SQL table using sqlDataReader.
  One of the columns contains DateTime, and is pulled from the sql and displayed correctly, using:</p>
  
  <pre><code>var datestring = reader.GetDateTime(reader.GetOrdinal("deadline")).ToShortDateString();
  </code></pre>
  
  <p>It is shown in the DataGridView in the following format: <code>dd.MM.yyyy</code></p>
  
  <p>When I try to sort this, it sorts it after <code>dd</code>, no matter what the <code>MM</code> and <code>yyyy</code> info is.</p>
  
  <p>The datestring is put in the datagridview with the following command:</p>
  
  <pre><code>dgv_tasks.Rows.Add(tid, taskname, sidvariable, datestring);
  </code></pre>
  
  <p>Anyone knows why it's not sorting this as dates at all, just the number in <code>dd</code> ?</p>
  
  <p>(I've looked here for an answer, but none of the similar questions had a working answer).</p>