title: How to sort DataGridView Column by date in VB visual studio 2012?
body: <p>In my DGV, I have date list in the column (1):</p>
  
  <pre><code>11-Sep-2014
  11-May-2011
  11-Jan-2014
  11-Mar-2014
  12-Sep-2010
  </code></pre>
  
  <p>how to get descending result like this:</p>
  
  <pre><code>11-Sep-2014
  11-Mar-2014
  11-Jan-2014
  11-May-2011  
  12-Sep-2010
  </code></pre>
  
  <p>The Column(1) is not DateTime type but SortText type, I must set string like that. Could it sorted?</p>
  
  <p>I have tried using code:</p>
  
  <pre><code>DGV.Columns(1).SortMode = DGV.Sort(DGV.Columns(1), System.ComponentModel.ListSortDirection.Descending)
  </code></pre>
  
  <p>but it's useless, it don't sort by date :(</p>
  
  <p>this is my DGV: <img src="https://i.stack.imgur.com/TfkUW.jpg" alt="enter image description here"></p>
  
  <p>Okeh, this is my DGV code in brief:</p>
  
  <p>Imports System.Data.OleDb</p>
  
  <p>Public Class LapTransaksiSimpanan</p>
  
  <pre><code>Public Sub Koneksi()
      str = "provider=microsoft.jet.oledb.4.0;data source=dbkoperasi.mdb"
      Conn = New OleDbConnection(str)
      If Conn.State = ConnectionState.Closed Then
          Conn.Open()
      End If
  End Sub
  
  Sub TampilGrid()
      da = New OleDbDataAdapter("select * from LapTransaksiSimpanan", Conn)
      ds = New DataSet
      da.Fill(ds, "LapTransaksiSimpanan")
      DGV.DataSource = ds.Tables("LapTransaksiSimpanan")
  
      'on the below I wanna to sort the column, my code below is useless :(
      DGV.Sort(DGV.Columns(1), System.ComponentModel.ListSortDirection.Descending)
  
      DGV.Columns("ID_Simpanan").Width = 120
      DGV.Columns("NAK").Width = 37
      DGV.Columns("Tanggal").Width = 75
      DGV.Columns("Jumlah").Width = 110
  End Sub
  
  Private Sub Setoran_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
      Call Koneksi()
      Call TampilGrid()
  End Sub
  </code></pre>
  
  <p>End Class</p>