The time-date format problem is displayed in the GridView following are the basic common dates, the time format
Form |
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 and p present 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 |
|
Be aware of the following aspects when operating in the GridView (for example, {0:d}) 1. The column to bind if it is purely boundfiled type (below) < Asp:boundfield datafield= "SJ" headertext= "Time" readonly= "True" Dataformatstring= "{0:d}"/> The format shown is still 2006-11-25 0:00:00 to achieve the effect we want 2. The column you want to bind must be a template column as follows: To see the effect we want to see: 2006-11-25 < Asp:templatefield headertext= "Time" > < edititemtemplate> <asp:label id= "Label1" runat= " Server "text= ' <%# Eval (" SJ "," {0:d} ")%> ' ></asp:Label> </EditItemTemplate> < itemtemplate> <asp:label id= "Label2" runat= "Server" Text= ' <%# Bind ("SJ", "{0:d}")%> ' ></asp:Label> </ItemTemplate> </Asp:templatefield >