Replace
Gridview Controls
Boundfield The data row is set
Dataformatstring Attribute, but has no effect. We would like to remind you that you
Dataformatstring To make the formatted string set in the property take effect, you must
Boundfield The
Htmlencode Attribute
False (Table 1 And 2 In this way, the table can be formatted smoothly. 3 ).
Chart 1
Chart 2
Format the gridview with dataformatstring
Display Data in the gridview. If the data to be displayed has multiple decimal places, you just want it to display only two decimal places. in Delphi, you can simply use displayformat. net, I checked the msdn for half a day and found that Dataformatstring Yes, this function can be implemented, but how to set it does not work. Finally, we found that because 2.0 is for security consideration, we also need to set it at the same time. Htmlencode = false to make dataformatstring take effect . Leave a mark. You don't need to waste more time when using it next time. And, Dataformatstring = "{0: f}", which is the default format and displays two decimal places If the number of decimal places to be displayed is another value, Dataformatstring = "{0: fn }" You can. Example: <Columns>
<Asp: boundfield datafield = "employeeid"/>
<Asp: boundfield datafield = "lastname"/>
<Asp: boundfield datafield = "birthdate" Htmlencode = "false" Dataformatstring = "{0: yyyy-mm-dd}"/>
</Columns>
Dataformatstring = "{0: Format String }"
{0} In dataformatstring represents the data itself, while the format string after the colon represents the format they want to display the data;
Number and currency format:
After the specified format symbol, you can specify the number of digits to be displayed in decimal places. For example, if the original data is "1.56" and the format is set to {0: N1}, the output is "1.5 」. The common numeric format is shown in the following table:
Format String input result
"{0: c}" 12345.6789 $12,345.68
"{0: c}"-12345.6789 ($12,345.68)
"{0: d}" 12345 12345
"{0: D8}" 12345 00012345
"{0: e}" 12345.6789 1234568e + 004
"{0: E10 }" 12345.6789 1.2345678900e + 004
"{0: F }" 12345.6789 12345.68
"{0: F0 }" 12345.6789 12346
"{0: g}" 12345.6789 12345.6789
"{0: G7}" 123456789 1.234568e8
"{0: n}" 12345.6789 12,345.68
"{0: N4}" 123456789 123,456,789.0000
"Total: {0: c}" 12345.6789 total: $12345.68
Common Date and Time formats:
Format description output format
D. Simplified Date Format: mm/DD/YYYY
D detailed Date Format: dddd, Mmmm DD, yyyy
F full format (long date + short time) dddd, Mmmm DD, yyyy hh: mm
F
Complete Date and Time Format
(Long date + long time)
Dddd, Mmmm DD, yyyy hh: mm: SS
G General Format (short date + short time) mm/DD/YYYY hh: mm
G General Format (short date + long time) mm/DD/YYYY hh: mm: SS
M, M month/day format mmmm dd
S moderate Date and Time Format: yyyy-mm-dd hh: mm: SS
T simplified time format hh: mm
T Detailed time format: hh: mm: SS