how to convert string to double with proper cultureinfo

Posted by Vinay Pandey on Stack Overflow See other posts from Stack Overflow or by Vinay Pandey
Published on 2010-04-06T07:49:24Z Indexed on 2010/04/06 7:53 UTC
Read the original article Hit count: 305

Filed under:

c#.net

|

globalization

|

localization

Hi All,

I have two nvarchar fields in database to store the DataType and DefaultValue, I have a DataType Double and value as 65.89875 in english format.

Now I want the user to see the value as per the selected browser language format (65.89875 in English should be displayed as 65,89875 in german). Now if the user edits from german format to 65,89875 which is 65.89875 equivalent in english, and the other user views from english browser it comes as 6589875.

This happens because in DB it was stored as 65,89875 and when converted using english culture it becomes 6589875 since it considers , as seperator.

Any Idea how I get this working for all the browsers?

© Stack Overflow or respective owner

Related posts about c#.net

C#/.NET Little Wonders: Of LINQ and Lambdas - A Presentation

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
Once again, in this series of posts I look at the parts of the .NET Framework that may seem trivial, but can help improve your code by making it easier to write and maintain. The index of all my past little wonders posts can be found here. Today I’m giving a brief beginner’s guide to LINQ and Lambdas… >>> More
How to Export data to Excel using LINQ to Entity?

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi I have the data coming from Entity Data model table on my ASP.NET page. Now I have to export this data into Excel on button click. If it is using OLEDB, it is straight forward as it is here: http://csharp.net-informations.com/excel/csharp-excel-oledb-insert.htm Here is my function to read data… >>> More
Crop and Resize Image to Specific Dimensions

as seen on Stack Overflow - Search for 'Stack Overflow'
I need some help cropping and resizing images using CSharp.net. My goal here is to take an image and reduce it to 50px by 50px. The following code I found here will do that, however it's scaling the image as well. Ideally I want to scale the image down to as close to 50px by 50px as possible and then… >>> More
CA2000 and disposal of WCF client

as seen on Stack Overflow - Search for 'Stack Overflow'
There is plenty of information out there concerning WCF clients and the fact that you cannot simply rely on a using statement to dispose of the client. This is because the Close method can throw an exception (i.e. if the server hosting the service doesn't respond). I've done my best to implement… >>> More
how to convert bitmap image to CIELab image?

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello to stackoverflow members! This is my first post but I love reading the questions and answers on this forum! I'm using VS2008, CSharp, NET 3.5 and Windows XP Pro latest patches on this project. I am reading in a jpeg file to a bitmap image using CSharp in the following… >>> More

Related posts about globalization

Script globalization of MicrosoftAjax.js in ASP.NET MVC

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, Could you write where I can find (or where you found ;)) globalization files (e.g. zu-ZA.js), I can't find that files in Microsoft AJAX Library 3.5. Best regards, Michal >>> More
jQuery Globalization Plugin from Microsoft

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
Last month I blogged about how Microsoft is starting to make code contributions to jQuery, and about some of the first code contributions we were working on: jQuery Templates and Data Linking support. Today, we released a prototype of a new jQuery Globalization Plugin that enables you to add globalization… >>> More
Supply Chain Globalization and the changes in the world of Manufacturing

as seen on Oracle Blogs - Search for 'Oracle Blogs'
John Barcus, Senior Director, Supply Chain Applications talks with Fred about the important current trends for Manufacturers, supply chain globalization as well as the role of technology in the Manufacturing space. >>> More
Globalization in WPF or Silverlight

as seen on Code Project - Search for 'Code Project'
Dynamic globalization for WPF and Silverlight apps without breaking design time. >>> More
Globalization Challenges and Opportunities: A Conversation with The Boston Consulting Group's Hal Si

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Hal Sirkin, Globalization Practice Manager at The Boston Consulting Group and author of the new book Globality, talks with Folia Grace, Oracle's Vice President of ERP Product Marketing, about the seven struggles all companies face as global competition intensifies, and the strategies you can adopt… >>> More