Date format shows seconds in dropdownlist asp.net -

i have pretty simple problem guess..

in db have date field orderdate format yyyy-mm-dd

now want make dropdownlist show distinct orderdates have in db when test dropdownlist in browser don't take format sql db. instead of yyyy-mm-dd writes dd.mm.yyyy 00:00:00

why , how can change it? have present date db string?

<p>     datum:     <asp:dropdownlist id="dropdownlist1" runat="server" datasourceid="sqldatasource1" datatextfield="orderdate" datavaluefield="orderdate">     </asp:dropdownlist>     <asp:sqldatasource id="sqldatasource1" runat="server" connectionstring="<%$ connectionstrings:eventconnectionstring %>" selectcommand="select distinct orderdate orders"></asp:sqldatasource> </p> 

add datatextformatstring="{0:dd/mm/yyyy}" in dropdownlist ,

<asp:dropdownlist id="dropdownlist1"       runat="server"       datasourceid="sqldatasource1"       datatextfield="orderdate"       datavaluefield="orderdate"       datatextformatstring="{0:dd/mm/yyyy}"> </asp:dropdownlist> 

or

code behind ,

dropdownlist1.datatextformatstring = "{0:dd/mm/yyyy}"; 

you can reference datetime format string !