Negative Values In GridView?

Question

0.00/5 (No votes)

See more:

Hi all,

In Grid View
positive amounts are displaying like this $155.00
negative amounts are displaying like this ($155.00)

I want to display the negative like -$155.00

<asp:BoundField DataField="Price" DataFormatString="{0:c}"
 HeaderText="Price">

plz correct me on this.

Thanks & Regards,
Pawan.

Posted 5-Apr-11 21:06pm

Pawan Kiran

Updated 5-Apr-11 21:09pm

Brijesh Kr

Add a Solution

2 solutions

Solution 2

Uae a TemplateField instead:

http://msdn.microsoft.com/en-us/library/bb288032.aspx[^]

Your code woould then be something like:

XML

<asp:TemplateField HeaderText="Price">
    <ItemTemplate>
        <asp:Label ID="Label1" runat="server" Text='$<%#
            Bind("Price") %>'>
        </asp:Label>
    </ItemTemplate>
</asp:TemplateField>

Posted 5-Apr-11 21:17pm

jim lahey

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Accepted Answer · 2011-04-05T21:14:00

Solution 1

Set HTMLEncoded to false and then use this format string:

{0:$#,##0.00;-$#,##0.00);0}

Should do it!

Posted 5-Apr-11 21:14pm

OriginalGriff

Comments

Pawan Kiran 6-Apr-11 3:35am

Vote of 5 and Thank U.

OriginalGriff 6-Apr-11 3:55am

You're welcome!

Hernan K. Cabrera 3-May-11 5:08am

Great...

Can I color the negative value red? How?

Thanks.

Hernan K. Cabrera 3-May-11 5:12am

I did it in rowdatabound event. Is there a property that I could use to do the coloring?

sharma-anurag 20-Dec-12 9:01am

thanks for give such a great thing

OriginalGriff 20-Dec-12 9:32am

You're welcome!

Negative Values In GridView?

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Negative Values In GridView?

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us