<div>
dim str as string = CMAReader(&quot;Bath&quot;)<br />
<br />
cmareader.LastIndexOf(&quot;&lt;/&quot;<wbr />)<br />
if string.Substring ( str , str.LastIndexOf(&quot;.&quot;) +1 , lstr.Length - str.LastIndexOf) = 0 then<br />
<br />
&nbsp;String.Format(CMAReader(&quot;B<wbr />ath&quot;), &quot;0.#&quot;)<br />
else<br />
&nbsp;String.Format(CMAReader(&quot;B<wbr />ath&quot;), &quot;0#&quot;)<br />
end if
</div>


dim str as string = CMAReader("Bath")

cmareader.LastIndexOf("</")
if string.Substring ( str , str.LastIndexOf(".") +1 , lstr.Length - str.LastIndexOf) = 0 then

 String.Format(CMAReader("Bath"), "0.#")
else
 String.Format(CMAReader("Bath"), "0#")
end if

<div>
Thanks for some direction on this. After looking at your suggestion and playing a bit I have used<br />
CMAReader(&quot;Bath&quot;).TrimEnd(<wbr />&quot;0&quot;).TrimE<wbr />nd(&quot;.&quot;)<br />

</div>


Thanks for some direction on this. After looking at your suggestion and playing a bit I have used
CMAReader("Bath").TrimEnd("0").TrimEnd(".")


<div>
<div class="content wysiwyg-content">
In VB.NET how does one format a floating point number so the decimal only displays if it exists?<br />
<br />
I am pulling data from a MySQL database where one of the columns is FLOAT(4,1) UNSIGNED. When I display the data on my ASP.NET page I only want the decimal to show if it is significant, ie.<br />
1.0 should display as 1<br />
1.5 should display as 1.5<br />
<br />
At the moment I have <br />
&nbsp; String.Format(CMAReader(&quot;B<wbr />ath&quot;), &quot;0.#&quot;)<br />
but this still displays 1.0 as 1.0
</div>
</div>


In VB.NET how does one format a floating point number so the decimal only displays if it exists?

I am pulling data from a MySQL database where one of the columns is FLOAT(4,1) UNSIGNED. When I display the data on my ASP.NET page I only want the decimal to show if it is significant, ie.
1.0 should display as 1
1.5 should display as 1.5

At the moment I have 
  String.Format(CMAReader("Bath"), "0.#")
but this still displays 1.0 as 1.0

Formatting floating point numbers

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications

ASP.NET

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,