Solved

Format a number in a gridview template

Posted on 2013-06-19
3
616 Views
Last Modified: 2013-06-19
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
Comment
Question by:Dovberman
  • 2
3 Comments
 
LVL 12

Accepted Solution

by:
Jitendra Patil earned 300 total points
ID: 39259396
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
 

Author Comment

by:Dovberman
ID: 39259684
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
 

Author Closing Comment

by:Dovberman
ID: 39259686
Thank you.
0

Featured Post

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

IntroductionWhile developing web applications, a single page might contain many regions and each region might contain many number of controls with the capability to perform  postback. Many times you might need to perform some action on an ASP.NET po…
A theme is a collection of property settings that allow you to define the look of pages and controls, and then apply the look consistently across pages in an application. Themes can be made up of a set of elements: skins, style sheets, images, and o…
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

762 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

22 Experts available now in Live!

Get 1:1 Help Now