Home > DeveloperSection > Forums > how to round decimal value in Gridview
 Ask Question

how to round decimal value in Gridview

Total Post:110

Points:776

 1574  View(s)
Ratings:
Rate this:

I am trying to round the result of my code to 2 decimal places, but ROUND isn't working. Any help? Thanks!

<asp:SqlDataSource ID="SqlDataSource1"runat="server" 
    
ConnectionString="<%$ ConnectionStrings:ConnectionString
%>" 
    
SelectCommand="SELECT [Id], [attempts], [total], (round(attempts /
total,(2))) AS [Percentage] FROM [Game]">
</asp:SqlDataSource>
  1. Re: how to round decimal value in Gridview

    Hi Jeet, 


    try this:

    CAST(ROUND(attempts/total,2) as DECIMAL(12,2))
    OR
    attempts/CAST(total as DECIMAL(12,2))
    OR
    CAST(attempts AS DECIMAL(12,2))/total

      Modified On Apr-06-2018 11:41:32 PM

Answer

Please check, If you want to make this post sponsored

You are not a Sponsored Member. Click Here to Subscribe the Membership.

© Copyright © 2010 - 2019 MindStick Software Pvt. Ltd. All Rights Reserved

DO YOU WISH TO IMPROVE YOUR BUSINESS ?

Once you’ve signed up as a user for a sponsorship on MindStick network, you will receive sponsored posting opportunities to apply for. It’s a great way to promote your product as a brand.

Yes, help me to improve my business No thanks x