sorting only the datewise not monthwise and year
<h2>coding for sorting:</h2>

<pre><code>DateTime dt = DateTime.Now;         
DataView dw = PurchaseRequestDetails.Tables[0].DefaultView;        
dw.Sort = "RequiredDate ASC"; 

foreach (DataRowView dr in dw)     
{
    dt = Convert.ToDateTime(dr["RequiredDate"]);

    System.Diagnostics.Debug.WriteLine("RequiredDate: " + dt.ToString("dd-MMM-yyyy")); 
}

dgvPurReq.DataSource = dw;    
dgvPurReq.DataBind();
</code></pre>

<hr>

<p>My issue is it is sorting only date-wise, not month wise and year wise
eg:</p>

<pre><code>01-aug-2010
03-jan-2009
06-dec-2010
09-aug-2010
</code></pre>

<hr>
