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,
DovbermanAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Jitendra PatilConnect With a Mentor Sr.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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.