DataFormatStrin g not working on a GridView DateTime column

[Rob Roberts]

I have a GridView that is bound to a collection of DateTimes (i.e. -
Collection<Date Time>). I have a BoundField in the GridView, and its
DataField is set to the DateTime's Date property, and the DataFormatStrin g
is set to "{0:d}" in order to display the date in short date format (without
the time). But the DataFormatStrin g doesn't seem to have any effect. The
DateTime gets displayed with the time.

I have another GridView that is bound to a collection of business objects,
and the business objects have a DateTime property. One of the columns in
the GridView has a BoundField that uses this DateTime property as its
DataField. In this case, the "{0:d}" DataFormatStrin g works as it should.
(The DateTime is displayed in short date format, without the time.) So it
works in this case, but not when I have the GridView bound to a collection
of DateTimes.

I've worked around the problem by using the RowDataBound event to manually
trim the time from the end of the cell's text, but that's a kludgy
workaround. Does anyone know why the DataFormatStrin g isn't working
correctly in this case?

Thanks in advance,
--Rob Roberts

[Teemu Keiski]

Hi,

set HtmlEncode="Fal se" to the BoundField.

Reason is that by default data is HTML-encoded before string formatting
takes place (which actually prevents string formatting to apply at all)
For an explanation see:
http://aspadvice.com/blogs/joteke/ar.../25/12871.aspx

--
Teemu Keiski
ASP.NET MVP, AspInsider
Finland, EU
http://blogs.aspadvice.com/joteke

"Rob Roberts" <ro************ @AndThisToo.pci sys.net> wrote in message
news:uV******** ********@TK2MSF TNGP04.phx.gbl. ..

I have a GridView that is bound to a collection of DateTimes (i.e. -
Collection<Dat eTime>). I have a BoundField in the GridView, and its
DataField is set to the DateTime's Date property, and the DataFormatStrin g
is set to "{0:d}" in order to display the date in short date format
(without the time). But the DataFormatStrin g doesn't seem to have any
effect. The DateTime gets displayed with the time.

I have another GridView that is bound to a collection of business objects,
and the business objects have a DateTime property. One of the columns in
the GridView has a BoundField that uses this DateTime property as its
DataField. In this case, the "{0:d}" DataFormatStrin g works as it should.
(The DateTime is displayed in short date format, without the time.) So it
works in this case, but not when I have the GridView bound to a collection
of DateTimes.

I've worked around the problem by using the RowDataBound event to manually
trim the time from the end of the cell's text, but that's a kludgy
workaround. Does anyone know why the DataFormatStrin g isn't working
correctly in this case?

Thanks in advance,
--Rob Roberts

[Rob Roberts]

"Teemu Keiski" <jo****@aspalli ance.com> wrote in message
news:OH******** ******@TK2MSFTN GP03.phx.gbl...

Hi,

set HtmlEncode="Fal se" to the BoundField.

Yes, that fixed it. Thank you!

--Rob Roberts