Solved

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

Posted on 2008-10-29
1
1,438 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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Introduction This article shows how to use the open source plupload control to upload multiple images. The images are resized on the client side before uploading and the upload is done in chunks. Background I had to provide a way for user…
Problem Hi all,    While many today have fast Internet connection, there are many still who do not, or are connecting through devices with a slower connect, so light web pages and fast load times are still popular.    If your ASP.NET page …
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

746 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now