forum

Home / DeveloperSection / Forums / how to round decimal value in Gridview

Ask Question

how to round decimal value in Gridview

Anonymous User 2075 20-Nov-2014

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>
asp.net asp.net  gridview 
Updated on 20-Nov-2014
Anonymous User

Anonymous User

Follow
I am a content writter !

Can you answer this question?

Answer

1 Answers

Sumit Kesarwani

Sumit Kesarwani

20-Nov-2014
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

Liked By