Groups | Blog | Home
all groups > asp.net announcements > july 2004 >

asp.net announcements : Changing decimal simbol in a dataset


Andrés Giraldo
7/9/2004 2:04:48 PM
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 ***
Andrés Giraldo
7/10/2004 7:29:57 AM
Hi!

Thanks for answer me, as I said before, the dataset is filled with a SQL
Server store procedure, it keeps it's dbschema, the type of the column
on the dataset is Decimal, and the type of the column on the SQL Server
table is numeric(18,3).

Thanks for any advice.

*** Sent via Devdex http://www.devdex.com ***
Miha Markic [MVP C#]
7/10/2004 10:01:07 AM
Hi,

What type is your DataColumn (column of dataset that holds the value)?
Is it string or numeric?

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

[quoted text, click to view]

AddThis Social Bookmark Button