Howard Katz
asked on
Format currency in ItemTemplate
Hi,
How would I get this to appear as currency.
<%# (Convert.ToDouble(Eval("Qu antity")) * Convert.ToDouble(Eval("Uni tCost")))% >
this is in an asp.net 4.0 application
Thanks
How would I get this to appear as currency.
<%# (Convert.ToDouble(Eval("Qu
this is in an asp.net 4.0 application
Thanks
<%# Format((Convert.ToDouble(E val("Quant ity")) * Convert.ToDouble(Eval("Uni tCost"))), "c")%>
'<%#Format(Convert.ToDoubl e(Eval("ne tQty")*Eva l("UnitCos t")),"c") %>'
ASKER
Thanks to both of you but neither suggestion has an effect. Here is the code that surrounds this line. It is in a gridview.
<Columns>
<asp:BoundField DataField="ProductID" HeaderText="Product ID" ....
<asp:BoundField DataField="ModelNumber" HeaderText="Model Number" ....
<asp:BoundField DataField="ModelName" HeaderText="Model Name" ....
<asp:BoundField DataField="UnitCost" HeaderText="Unit Cost" DataFormatString="{0:c}" />
<asp:TemplateField>
<HeaderTemplate>Quantity</ HeaderTemp late>
<ItemTemplate>
<asp:TextBox runat="server" Text='<%# Bind("Quantity") %>' />
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField>
<HeaderTemplate>Item Total</Hea derTemplat e>
<ItemTemplate>
<%# (Convert.ToDouble(Eval("Qu antity")) * Convert.ToDouble(Eval("Uni tCost")))% >
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField>
<HeaderTemplate>Remove&nbs p;Item</He aderTempla te>
<ItemTemplate>
<center>
<asp:CheckBox id="Remove" runat="server" />
</center>
</ItemTemplate>
</asp:TemplateField>
</Columns>
<Columns>
<asp:BoundField DataField="ProductID" HeaderText="Product ID" ....
<asp:BoundField DataField="ModelNumber" HeaderText="Model Number" ....
<asp:BoundField DataField="ModelName" HeaderText="Model Name" ....
<asp:BoundField DataField="UnitCost" HeaderText="Unit Cost" DataFormatString="{0:c}" />
<asp:TemplateField>
<HeaderTemplate>Quantity</
<ItemTemplate>
<asp:TextBox runat="server" Text='<%# Bind("Quantity") %>' />
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField>
<HeaderTemplate>Item
<ItemTemplate>
<%# (Convert.ToDouble(Eval("Qu
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField>
<HeaderTemplate>Remove&nbs
<ItemTemplate>
<center>
<asp:CheckBox id="Remove" runat="server" />
</center>
</ItemTemplate>
</asp:TemplateField>
</Columns>
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
What else should I do.
http://www.regexlib.com/DisplayPatterns.aspx (Regular Expression to validate)
decimal moneyvalue = your value;
string html = String.Format("Order Total: {0:C}", moneyvalue);
Console.WriteLine(html);
(C# String format code)