title: Sort Data by date in Asc in Access in c#
body: <p>I want fetch data based on date in ascending. The code is fetching data but in wrong format e.g.:</p>
  
  <pre><code>14/02/2014
  16/01/2014
  17/04/2013
  </code></pre>
  
  <p>i.e dates is sort based on "dd" only month and year is not considered
  the code is below</p>
  
  <pre><code>string constr = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\Auto_Finance.accdb;Persist Security Info=False;";
  OleDbConnection con = new OleDbConnection(constr);
  con.Open();
  string sql=@"select p.PName,p.hpno,c.Credit,C.Debit,c.Dates from Party_Det p inner join cd c on p.Loanno=c.Loanno order by c.Dates asc";
  OleDbCommand cmd = new OleDbCommand(sql, con);
  OleDbDataAdapter da = new OleDbDataAdapter(cmd);
  DataTable dt = new DataTable();
  da.Fill(dt);
  dataGridView1.DataSource = dt;
  con.Close();
  </code></pre>
  
  <p>But I want result like below </p>
  
  <pre><code>17/04/2013
  16/01/2014
  14/02/2014
  </code></pre>
  
  <p>I am using c# as front end and Microsoft Access as front end.</p>