String to Decimal conversion with Culture

Asked Jan 25 '17 at 03:41

Active Jan 25 '17 at 03:41

Viewed 237 times

I have a piece of code that read data from excel file store it in DB.

`decimal num = Convert.ToDecimal(rowOptions["excel_cl_name"]);`

But it does not work properly for NL culture. Let say when value is 878,90 it should be 878.9000 but it becomes 87890.0000. When value is 123,5 , it should be 123.5000 but it becomes 1235.0000. When value is 123 then it is 123.0000.

I cannot replace the ',' with space and divide the number by 100 as for other 2 cases it will fail.

Note: In database precision is 4.

Is there any way I can force the culture to be en-us always ? Is there a better way to manage it? I can also have value like 12.345,90 which is 12,345.9000.

asked Jan 25 '17 at 03:41

user1926138

1,464
7
34
53

Have you tried like this? `string amountFromDB = "878,90";` `decimal actualAmount = Convert.ToDecimal(amountFromDB, new CultureInfo("en-US"));` – M. Adeel Khalid Jan 25 '17 at 05:42
@MAdeelKhalid, yes tried, It throw Input string was not in a correct format exception – user1926138 Jan 25 '17 at 06:06
Have you traced what was the value when exception occurred? – M. Adeel Khalid Jan 25 '17 at 07:26
Is the data in the Excel file stored as a Decimal or as a String? – VDWWD Jan 25 '17 at 15:39
Does Nz culture has Comma as decimal separator or dot ? I believe it is dot and hence the result. – Anu Viswan Jan 30 '17 at 14:48

String to Decimal conversion with Culture

0 Answers0