GredView {0:d} formatting doesn't work

S

Shimon Sim

I just don't understand what is wrong.
I have simple query. One of the returning fields is data

I created bound column for GridView (ASP.NET 2.0) and specified
DataFormatString
as {0:d} - it returns me the row date with hours.
I tried something like this {0 :dd/MM/yyyy} the same results.
It looks like that system doesn't recognize that the field is date. Why not?
What can be done?
Thank you,
Shimon
 
A

Andrew Robinson

note sure if this is by design of if it is a bug, but turn of HTML Encoding.
Your data will format.
 
S

Steven Cheng[MSFT]

Hi Shimon,

As for the GridView DataField's DataFormatString not working problem, I
think it is because the new "HtmlEncode" setting provided for the
DataField. This property is set to "true" by default, thus the bound data
on that column will be htmlencoded before render out to response stream...
And set Htmlencode to true will prevent the DataFormatString from
working. So I think you can try disabling the "HtmlEncode" on that
DataField so as to make DataFormatString take effect, e.g:

<asp:BoundField DataField="OrderDate" HeaderText="OrderDate"
SortExpression="OrderDate" DataFormatString="{0:yy/mm/dd}"
HtmlEncode="false"/>

Hope helps. Thanks,

Steven Cheng
Microsoft Online Support

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)



--------------------
| From: "Shimon Sim" <[email protected]>
| Subject: GredView {0:d} formatting doesn't work
| Date: Wed, 23 Nov 2005 22:51:45 -0500
| Lines: 13
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
| X-RFC2646: Format=Flowed; Original
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
| Message-ID: <[email protected]>
| Newsgroups: microsoft.public.dotnet.framework.aspnet
| NNTP-Posting-Host: ool-44c05922.dyn.optonline.net 68.192.89.34
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP10.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl
microsoft.public.dotnet.framework.aspnet:360619
| X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet
|
| I just don't understand what is wrong.
| I have simple query. One of the returning fields is data
|
| I created bound column for GridView (ASP.NET 2.0) and specified
| DataFormatString
| as {0:d} - it returns me the row date with hours.
| I tried something like this {0 :dd/MM/yyyy} the same results.
| It looks like that system doesn't recognize that the field is date. Why
not?
| What can be done?
| Thank you,
| Shimon
|
|
|
 
S

Steven Cheng[MSFT]

You're welcome Shimon,

Regards,

Steven Cheng
Microsoft Online Support

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)

--------------------
| From: "Shimon Sim" <[email protected]>
| References: <[email protected]>
<[email protected]>
| Subject: Re: GredView {0:d} formatting doesn't work
| Date: Thu, 24 Nov 2005 09:15:51 -0500
| Lines: 68
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
| X-RFC2646: Format=Flowed; Original
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
| Message-ID: <[email protected]>
| Newsgroups: microsoft.public.dotnet.framework.aspnet
| NNTP-Posting-Host: ool-44c05922.dyn.optonline.net 68.192.89.34
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP14.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl
microsoft.public.dotnet.framework.aspnet:360726
| X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet
|
| Thank you,
| that worked.
| Shimon.
|
|
| | > Hi Shimon,
| >
| > As for the GridView DataField's DataFormatString not working problem, I
| > think it is because the new "HtmlEncode" setting provided for the
| > DataField. This property is set to "true" by default, thus the bound
data
| > on that column will be htmlencoded before render out to response
stream...
| > And set Htmlencode to true will prevent the DataFormatString from
| > working. So I think you can try disabling the "HtmlEncode" on that
| > DataField so as to make DataFormatString take effect, e.g:
| >
| > <asp:BoundField DataField="OrderDate" HeaderText="OrderDate"
| > SortExpression="OrderDate"
DataFormatString="{0:yy/mm/dd}"
| > HtmlEncode="false"/>
| >
| > Hope helps. Thanks,
| >
| > Steven Cheng
| > Microsoft Online Support
| >
| > Get Secure! www.microsoft.com/security
| > (This posting is provided "AS IS", with no warranties, and confers no
| > rights.)
| >
| >
| >
| > --------------------
| > | From: "Shimon Sim" <[email protected]>
| > | Subject: GredView {0:d} formatting doesn't work
| > | Date: Wed, 23 Nov 2005 22:51:45 -0500
| > | Lines: 13
| > | X-Priority: 3
| > | X-MSMail-Priority: Normal
| > | X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
| > | X-RFC2646: Format=Flowed; Original
| > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
| > | Message-ID: <[email protected]>
| > | Newsgroups: microsoft.public.dotnet.framework.aspnet
| > | NNTP-Posting-Host: ool-44c05922.dyn.optonline.net 68.192.89.34
| > | Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP10.phx.gbl
| > | Xref: TK2MSFTNGXA02.phx.gbl
| > microsoft.public.dotnet.framework.aspnet:360619
| > | X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet
| > |
| > | I just don't understand what is wrong.
| > | I have simple query. One of the returning fields is data
| > |
| > | I created bound column for GridView (ASP.NET 2.0) and specified
| > | DataFormatString
| > | as {0:d} - it returns me the row date with hours.
| > | I tried something like this {0 :dd/MM/yyyy} the same results.
| > | It looks like that system doesn't recognize that the field is date.
Why
| > not?
| > | What can be done?
| > | Thank you,
| > | Shimon
| > |
| > |
| > |
| >
|
|
|
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
474,432
Messages
2,571,680
Members
48,796
Latest member
Greg L.

Latest Threads

Top