Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

How to format a BoundField in GridView to show a $ with 2 decimal points?

Posted on 2008-10-29
1
Medium Priority
?
1,448 Views
Last Modified: 2012-05-05
Hi experts!
I have the following code but the format is not working for me for some strange reason. Need your directions please. The fields I want to format like $0.00. These two fields in database have type of money. The output I get in my GridView is like 0.0000
I appreciate your help in advance.
<asp:GridView ID="gvReverseNoList" Font-Size="12px" Font-Names="Arial" runat="server" CellPadding="4" ForeColor="#333333" GridLines="None">
	<columns>
		<asp:BoundField DataField="Date" HeaderText="Date" SortExpression="Date" >
			<ItemStyle HorizontalAlign="Left" VerticalAlign="middle" />
		</asp:BoundField>
		<asp:BoundField DataField="Loss" HeaderText="Loss" SortExpression="Loss" HtmlEncode="false" HtmlEncodeFormatString="false" DataFormatString="{0:c}" >
			<ItemStyle HorizontalAlign="Left" VerticalAlign="Middle" />
		</asp:BoundField>                                        
		<asp:BoundField DataField="Expense" HeaderText="Expense" SortExpression="Expense" HtmlEncode="false" HtmlEncodeFormatString="false" DataFormatString="{0:c}" >
			<ItemStyle HorizontalAlign="Left" VerticalAlign="Middle" />
		</asp:BoundField>                                        
	</columns>
	<PagerSettings FirstPageText="First Page" LastPageText="Last Page" NextPageText="Next Page" PreviousPageText="Previous Page" />
	<FooterStyle BackColor="#7A829D" Font-Bold="True" ForeColor="White" />
	<RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
	<PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Left" />
	<SelectedRowStyle BackColor="#E2DED6" Font-Bold="False" ForeColor="#333333" />
	<HeaderStyle HorizontalAlign="left" BackColor="#FFFFFF" Font-Bold="True" ForeColor="Black" />
	<EditRowStyle BackColor="#999999" />
	<AlternatingRowStyle BackColor="White" ForeColor="#284775" />
</asp:GridView>

Open in new window

0
Comment
Question by:bryanche
1 Comment
 

Accepted Solution

by:
bryanche earned 0 total points
ID: 22835017
I found the solution myself. what I had to do was to wrap my output number data around "FormatCurrency" method.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Just a quick little trick I learned recently.  Now that I'm using jQuery with abandon in my asp.net applications, I have grown tired of the following syntax:      (CODE) I suppose it just offends my sense of decency to put inline VBScript on a…
The ECB site provides FX rates for major currencies since its inception in 1999 in the form of an XML feed. The files have the following format (reducted for brevity) (CODE) There are three files available HERE (http://www.ecb.europa.eu/stats/exch…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…
Suggested Courses

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question