Invalid sorting date column in .net

=======================================================================
Date sorting is not valid in data grid using asp.net.
-------------------------------------------------------

Hi i am using MS SQL Server 2000 on back end and on front end i am using ASP.NET to show the data while accessing data from table i want to sort date in descending order but it shows below invalid order.

4/10/2008
4/10/2008
4/10/2008
4/15/2008
4/15/2008
4/9/2008
4/9/2008
4/9/2008
9/10/2007


the exact order is

4/9/2008
4/9/2008
4/9/2008
4/10/2008
4/10/2008
4/10/2008
4/15/2008
4/15/2008
9/10/2007

which is not coming in front so if any one have idea plz guide me
Regards.
Ali.

Even i used below code in c# to sort my data table before its display but still sorting is not valid.

Code:

C#
//datatable is populated before all the below lines
//we can assign datatable as DataScource to data grid and bind also
//but the result will be the same as i discussed in this pose
DataView dv = datatable.DefaultView;
dv.Sort = "TaskDate";
// "TaskDate" is column of datatable
this.dgTaskReport.DataSource = dv;
this.dgTaskReport.DataBind();
//dgTaskReport is data grid name

Hi,
You can add order by clause in your query. I am getting data without order by clause as below
06/11/08
06/10/08
06/09/08
06/08/08
06/07/08
06/06/08
04/22/08
03/23/08
After adding below order by clause in my query. I am getting data as per your requirement.
06/06/08
06/07/08
06/08/08
06/09/08
06/10/08
06/11/08
04/22/08
03/23/08
order by clause: ORDER BY DATEPART(DD,<datecolumnname>)

By Looking at the sorted data, I think the date column is considered as character column.
Can you try to cast it to datetime and then ordering by that.