formatting numbers

[Highpotech IT]

i'am using the following statement to format a aql string
sql=string.format("INSERT INTO werkboek VALUES {0}, {1}....;"
m_WNR, m_Aantal...)
Aantal is a decimal and evaluates into 2.5D. Evalutating the sql strin
i get:
"INSERT INTO werkboek VALUES 7, 2,5....;"
I've changed te code for the placeholder {1} to {1:#.00} in order to
change te output to 2.5 instead of 2,5 but no luck.
Is there a other way to change ste code to get te requered output te
read:
"INSERT INTO werkboek VALUES 7, 2.5....;"

Thanks in advance
Alexander M. Polak
mailto:am******@highpotech.nl

[Jon Skeet [C# MVP]]

Highpotech IT <am******@highpotech.nl> wrote:

i'am using the following statement to format a aql string
sql=string.format("INSERT INTO werkboek VALUES {0}, {1}....;"
m_WNR, m_Aantal...)
Aantal is a decimal and evaluates into 2.5D. Evalutating the sql strin
i get:
"INSERT INTO werkboek VALUES 7, 2,5....;"
I've changed te code for the placeholder {1} to {1:#.00} in order to
change te output to 2.5 instead of 2,5 but no luck.
Is there a other way to change ste code to get te requered output te
read:
"INSERT INTO werkboek VALUES 7, 2.5....;"

Rather than formatting the values, use parameters instead.

See http://www.pobox.com/~skeet/csharp/faq/#db.parameters

--
Jon Skeet - <sk***@pobox.com>
http://www.pobox.com/~skeet
If replying to the group, please do not mail me too

[Alexander M. Polak]

Tanks.
Using parems creates a new problem the one i wantted to avoid. So your
suggestion is no answer to the quistion at hand
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Highpotech IT]

Rather then using an other approch I'like to use the one i want and to
solve the problem at hand.

Tanks anyway

Jon Skeet [C# MVP] <sk***@pobox.com> wrote in message news:<MP***********************@msnews.microsoft.c om>...

Highpotech IT <am******@highpotech.nl> wrote:

i'am using the following statement to format a aql string
sql=string.format("INSERT INTO werkboek VALUES {0}, {1}....;"
m_WNR, m_Aantal...)
Aantal is a decimal and evaluates into 2.5D. Evalutating the sql strin
i get:
"INSERT INTO werkboek VALUES 7, 2,5....;"
I've changed te code for the placeholder {1} to {1:#.00} in order to
change te output to 2.5 instead of 2,5 but no luck.
Is there a other way to change ste code to get te requered output te
read:
"INSERT INTO werkboek VALUES 7, 2.5....;"

Rather than formatting the values, use parameters instead.

See http://www.pobox.com/~skeet/csharp/faq/#db.parameters

[Jon Skeet [C# MVP]]

Alexander M. Polak <am******@highpotech.nl> wrote:

Using parems creates a new problem the one i wantted to avoid. So your
suggestion is no answer to the quistion at hand

Well, I'd suggest that using parameters is still likely to be a better
solution, even if you then have to solve other problems - embedding
literals in SQL statements comes with all kinds of problems. (SQL
injection attacks, determining the input format for things like dates,
numbers etc, performance, to name just a few.)

However, if you specify CultureInfo.InvariantCulture before your format
string, I think that will solve your immediate problem.

--
Jon Skeet - <sk***@pobox.com>
http://www.pobox.com/~skeet
If replying to the group, please do not mail me too