When I get databack in datagrid in asp.net thru access, by following
query ,

select empno,birthdt from empmstr order by birthdt;

it is not giving results properly. it gives results as date sorted
(day sorted order) and not full date sorted order.

Can anybody help me out ?