Solved

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

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

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

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

Suggested Solutions

A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…

911 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

20 Experts available now in Live!

Get 1:1 Help Now