How to convert string to double with proper cultureinfo

by

You need to define a single locale that you will use for the data stored in the database, the invariant culture is there for exactly this purpose.

When you display convert to the native type and then format for the user’s culture.

E.g. to display:

string fromDb = "123.56";
string display = double.Parse(fromDb, CultureInfo.InvariantCulture).ToString(userCulture);

to store:

string fromUser = "132,56";
double value;
// Probably want to use a more specific NumberStyles selection here.
if (!double.TryParse(fromUser, NumberStyles.Any, userCulture, out value)) {
  // Error...
}
string forDB = value.ToString(CultureInfo.InvariantCulture);

PS. It, almost, goes without saying that using a column with a datatype that matches the data would be even better (but sometimes legacy applies).

More Related Contents:

  1. .NET (3.5) formats times using dots instead of colons as TimeSeparator for it-IT culture?
  2. How can I detect the encoding/codepage of a text file
  3. Exception messages in English?
  4. How to make multi-language app in Winforms?
  5. Single-assembly multi-language Windows Forms deployment (ILMerge and satellite assemblies / localization) – possible?
  6. Currency format for display
  7. Best way to implement multi-language/globalization in large .NET project
  8. ASP.NET Core Model Binding Error Messages Localization
  9. Programmatic way to get all the available languages (in satellite assemblies)
  10. How do I change the culture of a WinForms application at runtime
  11. Proper localization of a WinForms application
  12. String format currency
  13. Proper way to change language at runtime
  14. MessageBox buttons – set language?
  15. Formatting Numbers as Strings with Commas in place of Decimals
  16. How to set text to a control from resource file in design time?
  17. ExecuteReader requires an open and available Connection. The connection’s current state is Connecting
  18. Has an event handler already been added?
  19. No output to console from a WPF application?
  20. How do I run a simple bit of code in a new thread?
  21. Bring a window to the front in WPF
  22. Two-way / bidirectional Dictionary in C#?
  23. Weak event handler model for use with lambdas
  24. How to read a .NET Guid into a Java UUID
  25. Using HashSet in C# 2.0, compatible with 3.5
  26. How do I tell if a type is a “simple” type? i.e. holds a single value
  27. The component does not have a resource identified by the uri
  28. Calling an async method from a synchronous method
  29. Change ComboBox Border Color in Windows Forms
  30. How to send keys instead of characters to a process?

Leave a Comment