Rounding Decimal in Gridview

Question

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>

Here is a [useful link](http://stackoverflow.com/questions/441600/write-a-number-with-two-decimal-places-sql-server) — शेखर, Nov 30 '13 at 04:38

score 0 · Accepted Answer · edited Nov 30 '13 at 03:06

0

I bet you could use

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

edited Nov 30 '13 at 03:06

Jeroen Vannevel

43,651
22
107
170

answered Nov 30 '13 at 01:17

Ross Bush

14,648
2
32
55

Thank you Jeroen! Actually, the first choice was the correct solution. – user3051022 Dec 12 '13 at 08:33

user3041913 · Answer 2 · 2013-12-02T11:04:25.157

0

try this " SelectCommand="SELECT [Id], [attempts], [total], round((attempts / total),2) AS [Percentage] FROM [Game]">

UPDATE:

Have you tried:

SELECT Cast( 2.555 as decimal(53,2))

This would return 2.55 . Is that what you want?

edited Dec 02 '13 at 11:04

answered Dec 02 '13 at 10:57

user3041913

31
3

Rounding Decimal in Gridview

2 Answers2