Problems whith decimal values in a datagrid and database

[fscsantos]

Problems with decimal values in a datagrid and database

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 table.

Datagrid does not allow to insert a value decimal with a point (example: 12.3), only leaves with a comma (example: 12,3) giving problems when I insert in the database, therefore in the database it does not leave to insert comma in the decimal values but point

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

Thanks for any suggestion!

 

[kulrom]

I "guess" you are talking about currency amounts. Well, 1st go to the control panel and see what is the lang under "Regional Options". Different cultures have different currencies format and of course you should format how they appear. Waiting for your feedback

Cheers