Display decimal places only if needed...

[Sean]

So I have a web form that accepts temperature readings...and sometimes
the reading is a round number (ex. 74), and other times its not (ex.
58.3). I have the database setup to accept numeric(4,1), which shows
74.0 and 58.3 great, but I'd really like to only show the decimal
place if it's not zero...is this possible? I've googled for this for
awhile now and can't seem to find an answer...thanks in advance.

-Sean

 

[=?ISO-8859-1?Q?G=F6ran_Andersson?=]

So I have a web form that accepts temperature readings...and sometimes
the reading is a round number (ex. 74), and other times its not (ex.
58.3). I have the database setup to accept numeric(4,1), which shows
74.0 and 58.3 great, but I'd really like to only show the decimal
place if it's not zero...is this possible? I've googled for this for
awhile now and can't seem to find an answer...thanks in advance.

-Sean

How are you reading the values from the database? What data type do you
convert the values to?

Normally when converting a floating point value to a string, when the
decimal part is zero it's not included. How do you convert the value to
a string for displaying?

 

[John Duval]

So I have a web form that accepts temperature readings...and sometimes
the reading is a round number (ex. 74), and other times its not (ex.
58.3). I have the database setup to accept numeric(4,1), which shows
74.0 and 58.3 great, but I'd really like to only show the decimal
place if it's not zero...is this possible? I've googled for this for
awhile now and can't seem to find an answer...thanks in advance.

-Sean

How about this?

http://msdn2.microsoft.com/en-us/library/0c899ak8(VS.71).aspx

static void Main()
{
decimal a = 58.3M;
decimal b = 74.0M;
string sa = a.ToString(".#"); // sa is "58.3"
string sb = b.ToString(".#"); // sb is "74"
}

John

 

[Sean]

They're read with an ObjectDataSource into a FormView most of the
time. I'll play around with converting them to strings to see what
kind of results I get.

-Sean