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();

drpStartYear.DataSource =_dstt.Tables["tbSettings"].DefaultView; drpStartYear.DataValueField = "StartDate"; drpStartYear.DataTextFormatString = "{0:d}"; drpStartYear.DataBind(); — Ubaid Ashraf, Jun 17 '13 at 11:36
I also want to conclude, datatextformatstring doesnot work if datavaluefield is used instead of datatextfield — Ubaid Ashraf, Jun 17 '13 at 11:41

Paul Alan Taylor · Accepted Answer · 2013-06-17T11:31:20.763

9

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

EDIT: Add this:

drpStartYear.DataTextField = "StartDate";

edited Jun 17 '13 at 11:31

answered Jun 17 '13 at 11:21

Paul Alan Taylor

10,474
1
26
42

I dont need time @Garath, but still above is not working, I know i need to use format as "{0:d}" , but how to set it in drop down list, that is giving me headache – Ubaid Ashraf Jun 17 '13 at 11:27

score 3 · Answer 2 · answered Jun 17 '13 at 11:32

3

You have to set DataTextField as well -

  drpStartYear.DataValueField = "StartDate";

  drpStartYear.DataTextField = "StartDate";
  drpStartYear.DataTextFormatString = "{0:dd-MM-yyyy}";
  drpStartYear.DataBind();

answered Jun 17 '13 at 11:32

Ondrej Svejdar

21,349
5
54
89

this is the answer, but I can mark only one as answer , sadly – Ubaid Ashraf Jun 17 '13 at 11:44

hutchonoid · Answer 3 · 2013-06-17T11:45:00.073

2

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

or you can set this in your mark-up as follows:

<asp:DropDownList
id="drpStartYear"
runat="server"
DataTextField = "StartDate"
DataTextFormatString="{0:dd-MM-yyyy}"/>

edited Jun 17 '13 at 11:45

answered Jun 17 '13 at 11:21

hutchonoid

32,982
15
99
104

It is not working, although "{0:d}" worked perfectly for setting date format of columns in GridView, where I used DataFormatString="{0:d}" , but how to do same in case of dropdown list – Ubaid Ashraf Jun 17 '13 at 11:25

score 0 · Answer 4 · answered Jun 17 '13 at 11:40

Below code worked for me, I was using DataValueField, which didnot allow me to use DataTextFormatString, So When I changed it to DataTextField, I got intended results :)

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

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

score -1 · Answer 5 · edited Jun 17 '13 at 11:25

-1

Did you try:

drpStartYear.DataTextFormatString = "0:dd/MM/yyyy HH:mm:ss";

edited Jun 17 '13 at 11:25

Anuj

1,496
1
18
28

answered Jun 17 '13 at 11:23

Piotr Stapp

19,392
11
68
116

OP doesn't require time part – Anuj Jun 17 '13 at 11:25
@Anuj DataTextFormatString doesnot work on using datavaluefield, that was the problem, when i used datatextfield, it solved my problem – Ubaid Ashraf Jun 17 '13 at 11:43

Setting Date format in dropdown list

5 Answers5

Linked