Numeric data type formatting after SqlDataReader

Question

I've got another issue, I have a SQL Server database in which I insert data using SqlCommand, one of the columns is numeric, but when I read this column back with this code:

 zcena1.Text = precti.GetDecimal(4).ToString();

the inserted button 123 is inserted as 123,00 (which is ok)

When I read it back it gives me back 123,00 is there any way to make it read like 123.00? Can I replace comma with dot?

apptimal · Accepted Answer · 2013-07-06 10:09:39Z

2

You could try this:

zcena1.Text = precti.GetDecimal(4).ToString().Replace(',', '.');

answered Jul 6, 2013 at 10:09

apptimal

4948 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Luis LL Over a year ago

This approach works well for a specific case. But best practices should be adopted, so if you application is going to run at different countries of continental Europe, you'll want to keep the comma instead of the dot. And that where the localization shows it's strength

marc_s · Accepted Answer · 2013-07-06 10:17:01Z

1

you should try working localized, look for

Decimal.Parse (String, IFormatProvider)

edited Jul 6, 2013 at 10:17

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

answered Jul 6, 2013 at 10:05

Luis LL

2,9932 gold badges21 silver badges22 bronze badges

Collectives™ on Stack Overflow

Numeric data type formatting after SqlDataReader

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related