Changing decimal simbol in a dataset

[Andrés Giraldo]

Hi!

I'm showing decimal values in a datagrid, but the decimal point shown is
the "," and the correct is the ".". The datagrid is filled with a
dataset, the dataset is filled with a SQL Server 2000 store procedure.

I'm running the client on the same machine of the database server and
the application server, on this machine it's regional configuration on
the control panel, the decimal simbol it's the "."...

so... how can I fix this? should I format on VB each column, each row of
the dataset?

Thanks for any suggestion!

*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!

 

[Cor Ligthert]

Andres,

The best is using the right setting of your OS in the culture it has to be,
when not you can maybe try one of this ones:

\\\set culture
Dim myCIintl As New System.Globalization.CultureInfo("nl-NL")
Application.CurrentCulture = myCIintl
'or
Thread.CurrentThread.CurrentCulture = New CultureInfo("en-US")
///

Know that it makes your application culture dependend.

I hope this helps?

Cor