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
<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