Setting Date format in dropdown list

Question

I am retrieving date values from dataset(_dsst) and populating them in dropdown list(drpStartYear).

Since I am storing date as datetime datatype, I am getting date values as mm-dd-yyyy 00:00:00 , where 00:00:00 is the time. But I need to get date only in dd-mm-yyyy format in dropdown list. I tried using datatextformatstring, but it is not working.

Below is the code:

 drpStartYear.DataSource = _dstt.Tables["tbSettings"].DefaultView;    
 drpStartYear.DataValueField = "StartDate";    

 drpStartYear.DataTextFormatString = "{0:d}";   
 drpStartYear.DataBind();    

Answer 1

drpStartYear.DataTextFormatString = "{0:dd-MM-yyyy}";

EDIT: Add this:

drpStartYear.DataTextField = "StartDate";