forum

home / developersection / forums / how to round decimal value in gridview

how to round decimal value in Gridview

Anonymous User 2423 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 gridview

Updated on 20-Nov-2014

Anonymous User

Other

I am a content writter !

Can you answer this question?

1 Answers

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

MindStick Training