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

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 649
  • Last Modified:

Format a number in a gridview template

I have a gridview template column that displays as 25.696249535833642

The display needs to be formatted to only one decimal place.  25.6 or 25.7 , Rounding is not important.

This is my column spec:

             <asp:TemplateField HeaderText="Pct Change" >
                    <ItemTemplate>
                    <asp:Label runat="server"
                        Text='<%# (Convert.ToDecimal(Eval("MaxClose")) -
                        Convert.ToDecimal(Eval("MinClose")))
                        /Convert.ToDecimal(Eval("MinClose")) *100 %>'>
                    </asp:Label>
                    </ItemTemplate>
                     <HeaderStyle HorizontalAlign="Left" Width="0.4in" />
                    <ItemStyle HorizontalAlign="Right" Width="0.4in" />
                </asp:TemplateField>

What do I need to change?

Thanks,
0
Dovberman
Asked:
Dovberman
  • 2
1 Solution
 
Jitendra PatilSr.Software EngineerCommented:
you can try String.Format("{0:c}", value)

  <asp:Label ID="lblText" Text=' <%# (String.Format("{0:c}", (Convert.ToDecimal(Eval("MaxClose")) - Convert.ToDecimal(Eval("MinClose"))) / Convert.ToDecimal(Eval("MinClose")) *100)) %>' runat="server"  ></asp:Label>


Hope this helps.
0
 
DovbermanAuthor Commented:
I will try your suggestion.

Meanwhile this worked:

               <asp:TemplateField HeaderText="Pct Chg" >
                    <ItemTemplate>
                    <asp:Label runat="server"
                        Text='<%# ((Convert.ToDecimal(Eval("MaxClose")) -
                        Convert.ToDecimal(Eval("MinClose")))
                        /Convert.ToDecimal(Eval("MinClose")) *100 ).ToString("F1")%>'>
                    </asp:Label>
                    </ItemTemplate>
                     <HeaderStyle HorizontalAlign="Left" Width="0.4in" />
                    <ItemStyle HorizontalAlign="Right" Width="0.4in" />
                </asp:TemplateField>

Thanks
0
 
DovbermanAuthor Commented:
Thank you.
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now