Jul 24, 2013
Formatting string in BoundField (money)
Sometimes we have data that represent money currency. For example, in database, we have 15470125 as data item. Then we have to display this kind of data in GridView row, using a bound field, but in "more humanity" look. So, this code will regenerate data in other form.
<asp:BoundField DataField="Currency" HeaderText="Currency (in IDR)" DataFormatString="{0:###,##0}" />
It will transform 15470125Â into 15,470,125
And this for date format
<asp:BoundField HeaderText="PostingDate" DataField="PostingDate" DataFormatString="{0:dd-MMM-yyyy}" />
for further information, take a look at this link : http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.boundfield.dataformatstring.aspx
