sqldatareaderobject.GetDecimal("ColumnName") is not taking comma as decimal separator

Question

Hi,

Our production server(Sql Server 2008 R2) in iceland and stores money column values as 234,67.

We are trying to read the column values as following way.

sqldatareaderobject.GetDecimal("<ColumnName>") then it returns as 23467. But it supposed to be returns as 234.67.

Please help me in this issue.

-Mastan

Answer 1

You haven't specified the type of application.

But you should put this before the creation of the object of your interface:

Application.CurrentCulture = System.Globalization.CultureInfo.CreateSpecificCulture("yourCulture");

Replace the yourCulture string, with a string representing the culture you need(i.e en-US for the US, de-DE for Germany).

Answer 2

Hi,

This is ASP.Net application with C#

Answer 3

Hi masthan80864,

You are more likely to get more efficient responses to ASP.NET issues at http://forums.asp.net where you can contact ASP.NET experts.

---

Bob Shen [MSFT]
MSDN Community Support | Feedback to us

Answer 4

Hi try this one i think it will help to u :(

string s=sqldatareaderobject["<ColumnName>"].ToString();

decimal d = decimal.Parse(s.Replace(',','.'), System.Globalization.NumberStyles.AllowDecimalPoint);

---

programmer on .net