Format text in label to amount

I'm populating a label with an amount like this:

lblBudget.Text = Generic_database_functions.GetValue("SELECT
ISNULL(Sum(Budget), 0) FROM vwPROJECTForecast")

I want the amount in the label to be shown as "10.000" not "10000".
How can I format the amount?

I'm very grateful for help!

// S

Re: Format text in label to amount

wrote in message
news:542351c6-f9e5-4714-be00-fbc6cef67dfe@d21g2000prf.google groups.com...
> I'm populating a label with an amount like this:
>
> lblBudget.Text = Generic_database_functions.GetValue("SELECT
> ISNULL(Sum(Budget), 0) FROM vwPROJECTForecast")
>
> I want the amount in the label to be shown as "10.000" not "10000".
> How can I format the amount?


I'm presuming that . is the thousand separator for the culture you're
using...

lblBudget.Text =
Convert.ToDecimal(Generic_database_functions.GetValue("SELEC T
ISNULL(Sum(Budget), 0) FROM vwPROJECTForecast")).ToString("#.##0")


--
Mark Rae
ASP.NET MVP
http://www.markrae.net

Re: Format text in label to amount

On 9 Jan, 15:02, "Mark Rae [MVP]" wrote:
> wrote in message
>
> news:542351c6-f9e5-4714-be00-fbc6cef67dfe@d21g2000prf.google groups.com...
>
> > I'm populating a label with an amount like this:
>
> > lblBudget.Text = Generic_database_functions.GetValue("SELECT
> > ISNULL(Sum(Budget), 0) FROM vwPROJECTForecast")
>
> > I want the amount in the label to be shown as "10.000" not "10000".
> > How can I format the amount?
>
> I'm presuming that . is the thousand separator for the culture you're
> using...
>
> lblBudget.Text =
> Convert.ToDecimal(Generic_database_functions.GetValue("SELEC T
> ISNULL(Sum(Budget), 0) FROM vwPROJECTForecast")).ToString("#.##0")
>
> --
> Mark Rae
> ASP.NET MVPhttp://www.markrae.net

Thank you for the help. Unfortunately I receive error message: "Input
string was not in a correct format".

(Yes, "." is the thousand separator).

// S

Re: Format text in label to amount

wrote in message
news:29f3724d-6997-4642-836d-9a8567691ea2@l1g2000hsa.googleg roups.com...

>> lblBudget.Text =
>> Convert.ToDecimal(Generic_database_functions.GetValue("SELEC T
>> ISNULL(Sum(Budget), 0) FROM vwPROJECTForecast")).ToString("#.##0")
>
> Thank you for the help. Unfortunately I receive error message: "Input
> string was not in a correct format".

What datatype does GetValue return...?


--
Mark Rae
ASP.NET MVP
http://www.markrae.net

Re: Format text in label to amount

On 10 Jan, 15:34, "Mark Rae [MVP]" wrote:
> wrote in message
>
> news:29f3724d-6997-4642-836d-9a8567691ea2@l1g2000hsa.googleg roups.com...
>
> >> lblBudget.Text =
> >> Convert.ToDecimal(Generic_database_functions.GetValue("SELEC T
> >> ISNULL(Sum(Budget), 0) FROM vwPROJECTForecast")).ToString("#.##0")
>
> > Thank you for the help. Unfortunately I receive error message: "Input
> > string was not in a correct format".
>
> What datatype does GetValue return...?
>
> --
> Mark Rae
> ASP.NET MVPhttp://www.markrae.net

It returns a string and it looks like this:

Shared Function GetValue(ByVal strSP As String)
Dim myConnection As New SqlConnection(ConnectionString)
Dim myCommand As New SqlCommand(strSP, myConnection)
myConnection.Open()
Dim strValue As String = myCommand.ExecuteScalar().ToString()
myConnection.Close()

Return strValue
End Function

// S

Re: Format text in label to amount

wrote in message
news:8cc75fdc-666d-4699-901c-8f219f73baba@s8g2000prg.googleg roups.com...

> On 10 Jan, 15:34, "Mark Rae [MVP]" wrote:
>> wrote in message
>>
>> news:29f3724d-6997-4642-836d-9a8567691ea2@l1g2000hsa.googleg roups.com...
>>
>> >> lblBudget.Text =
>> >> Convert.ToDecimal(Generic_database_functions.GetValue("SELEC T
>> >> ISNULL(Sum(Budget), 0) FROM vwPROJECTForecast")).ToString("#.##0")
>>
>> > Thank you for the help. Unfortunately I receive error message: "Input
>> > string was not in a correct format".
>>
>> What datatype does GetValue return...?
>
> It returns a string and it looks like this:
>
> Shared Function GetValue(ByVal strSP As String)
> Dim myConnection As New SqlConnection(ConnectionString)
> Dim myCommand As New SqlCommand(strSP, myConnection)
> myConnection.Open()
> Dim strValue As String = myCommand.ExecuteScalar().ToString()
> myConnection.Close()
>
> Return strValue
> End Function

OK, then. Please try the following and tell me where it fails:

Dim strGetValue As String
strGetValue = Generic_database_functions.GetValue("SELECT
ISNULL(Sum(Budget), 0) FROM vwPROJECTForecast")
Dim decValue As Decimal
decValue = Convert.ToDecimal(strGetValue)
lblBudget.Text = decValue.ToString("#.##0")



BTW, you should really put some exception handling in your function or, at
the very least, use the Using syntax... As it stands, any error in the
ExecuteScaler line is liable to leave your connection open...


--
Mark Rae
ASP.NET MVP
http://www.markrae.net

Re: Format text in label to amount

On 10 Jan, 17:10, "Mark Rae [MVP]" wrote:
> wrote in message
>
> news:8cc75fdc-666d-4699-901c-8f219f73baba@s8g2000prg.googleg roups.com...
>
>
>
>
>
> > On 10 Jan, 15:34, "Mark Rae [MVP]" wrote:
> >> wrote in message
>
> >>news:29f3724d-6997-4642-836d-9a8567691ea2@l1g2000hsa.googl egroups.com...=

>
> >> >> lblBudget.Text =3D
> >> >> Convert.ToDecimal(Generic_database_functions.GetValue("SELEC T
> >> >> ISNULL(Sum(Budget), 0) FROM vwPROJECTForecast")).ToString("#.##0")
>
> >> > Thank you for the help. Unfortunately I receive error message: "Input=

> >> > string was not in a correct format".
>
> >> What datatype does GetValue return...?
>
> > It returns a string and it looks like this:
>
> > Shared Function GetValue(ByVal strSP As String)
> > =A0 =A0 =A0 =A0Dim myConnection As New SqlConnection(ConnectionString)
> > =A0 =A0 =A0 =A0Dim myCommand As New SqlCommand(strSP, myConnection)
> > =A0 =A0 =A0 =A0myConnection.Open()
> > =A0 =A0 =A0 =A0Dim strValue As String =3D myCommand.ExecuteScalar().ToSt=
ring()
> > =A0 =A0 =A0 =A0myConnection.Close()
>
> > =A0 =A0 =A0 =A0Return strValue
> > End Function
>
> OK, then. Please try the following and tell me where it fails:
>
> Dim strGetValue As String
> strGetValue =3D Generic_database_functions.GetValue("SELECT
> ISNULL(Sum(Budget), 0) FROM vwPROJECTForecast")
> Dim decValue As Decimal
> decValue =3D Convert.ToDecimal(strGetValue)
> lblBudget.Text =3D decValue.ToString("#.##0")
>
> BTW, you should really put some exception handling in your function or, at=

> the very least, use the Using syntax... As it stands, any error in the
> ExecuteScaler line is liable to leave your connection open...
>
> --
> Mark Rae
> ASP.NET MVPhttp://www.markrae.net- Dölj citerad text -
>
> - Visa citerad text -

The problem is solved! Your code was completely correct and it was a
formula with additions containing the converted variables that caused
the error. Thank you for the help!

/ S

Re: Format text in label to amount

wrote in message
news:367e5b5a-87e1-4d71-81dc-ce16dd0e32da@21g2000hsj.googleg roups.com...
On 10 Jan, 17:10, "Mark Rae [MVP]" wrote:

> The problem is solved! Your code was completely correct and it was a
> formula with additions containing the converted variables that caused
> the error. Thank you for the help!

Phew! Thought I was going crazy for a second... :-)


--
Mark Rae
ASP.NET MVP
http://www.markrae.net