Issues such as time-date format display in GridView

form <?xml:namespace prefix = o ns = "Urn:schemas-microsoft-com:office:office"/>	Grammar	Results	Comments
Digital	{0:N2}	12.36
Digital	{0:n0}	13
Currency	{0:C2}	$12.36
Currency	{0:C4}	$12.3656
Currency	"￥{0:n2}"	￥12.36
Scientific counting method	{0:E3}	1.23E+001
Percentage	{0:p}	12.25%	P Case is the same
Date	{0:D}	November 25, 2006
Date	{0:D}	2006-11-25
Date	{0:f}	November 25, 2006 10:30
Date	{0:f}	November 25, 2006 10:30:00
Date	{0:s}	2006-11-25 10:30:00
Time	{0:t}	10:30:00

Note the following aspects when operating in the GridView (for example, {0:d})

1. The column to bind if it is purely boundfiled type (see below)

<asp:boundfield datafield= "SJ" headertext= "Time" readonly= "True" dataformatstring= "{0:d}"/>

The format shown is still 2008-11-18 14:20:32 to achieve the effect we want

2. The column to bind must be a template column as follows: To see the effect we want to see: 2008-11-18

<asp:templatefield headertext= "Time" >

<EditItemTemplate>

<asp:label id= "Label1" runat= "server" text= ' <%# Eval ("SJ", "{0:d}")%> ' ></asp:Label>

</EditItemTemplate>