Formatting Results from DB to show Decimals

Discussion in 'C#' started by Stoty, Feb 8, 2008.

0
  1. #1
    Hi there,

    I am having an issue with my page displaying the decimal places for whole numbers.
    In the database itself (mySQL), it shows up correctly (ex - 12.0), but when I display the result, it displays as just 12

    here is the code I am using to pull the result:

    <td><%=rsPlayers("Total") %></td>


    Is there anyway I can format that to have it show the decimal value for every number, even if its a whole?

    Thanks in advance for any help.

    *Stoty
     
    Stoty, Feb 8, 2008 IP
  2. mascix

    mascix Active Member

    Messages:
    64
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    93
    #2
    one way:
    <td><%=Convert.ToDouble(rsPlayers("Total")) %></td>

    another way:
    <td><%=Convert.ToDouble(rsPlayers("Total")).ToString("N") %></td>

    in second way you may do any formating if its needed. but before those lines I suggest you to play with your sql select for this. because it can be solved there.

    for more formatting details: http://msdn2.microsoft.com/en-us/library/dwhawy9k.aspx
     
    mascix, Feb 9, 2008 IP