I have to write an application that deals with clients in multiple countries.
The addresses, phone numbers, country id[social security number] and
currency information has to be stored into a database that allows for the
format of any country. I would like to be able to automatically display the
information in the format of their country based on the information gathered
from the Country field in the database.
Is there any white paper, or book or site that has information on designing
a component that will change it's format automatically so I can customize
the format on the fly instead of having so many different controls based on a
country. Or should I make several different controls and call them based on
the data retrieved from the database? I basically want to display the
address, phone number and SSN/Country ID in the format that is the standard
of the country that it comes from. For example I don't want to force users
to enter a phone number with a mask of (999) 999-9999 if they are in a
country that doesn't have that format. Or force the entry of a SSN when the
country utilizes a different format than 999-99-9999.
Thank you in advance for your help in my quest.
The following are the countries:
England, France, Germany, Switzerland, Holland, Spain, Portugal, Taiwan,
China [mainland and Hong Kong], Australia, Brazil, Mexico, Canada, France,
Italy, and Japan.
Thank you for any help.
--
Kamaluokeakua 5 3523
Hi,
There is tons of support for globalization in .NET so you're in luck.
Globalized & Localized currency, datetime, etc. formats are supported and you
can have seperate versions of your user interface forms for each culture; to
adjust GUI controls and add/remove fields per culture as needed. Also, if
SQL Server is your database there's lots of support for storing globalized
data - you need to consider that when you design your database.
I can't think of any good books offhand - though I guarantee there are
several out there - but here are some MSDN online links. Globalization is a
fairly large topic though, so get ready to do some heavy reading...
Intro articles: http://msdn.microsoft.com/msdnmag/is...2/06/internat/ http://msdn.microsoft.com/msdnmag/is...r/default.aspx
Supporting .NET framework classes: http://msdn.microsoft.com/library/de...Namespaces.asp http://msdn.microsoft.com/library/de...balization.asp
SQL Server topics {the books online link is for the latest update to SQL
Server 2000}: http://msdn.microsoft.com/archive/de...n_interntl.asp http://www.microsoft.com/sql/techinf...2000/books.asp
Other useful search keywords:
Globalization
Localization
Default culture
Currency format
DateTime format
Strong name
Culture fallback assembly
--Richard
"Kamaluokea kua" wrote: I have to write an application that deals with clients in multiple countries. The addresses, phone numbers, country id[social security number] and currency information has to be stored into a database that allows for the format of any country. I would like to be able to automatically display the information in the format of their country based on the information gathered from the Country field in the database.
Is there any white paper, or book or site that has information on designing a component that will change it's format automatically so I can customize the format on the fly instead of having so many different controls based on a country. Or should I make several different controls and call them based on the data retrieved from the database? I basically want to display the address, phone number and SSN/Country ID in the format that is the standard of the country that it comes from. For example I don't want to force users to enter a phone number with a mask of (999) 999-9999 if they are in a country that doesn't have that format. Or force the entry of a SSN when the country utilizes a different format than 999-99-9999.
Thank you in advance for your help in my quest. The following are the countries: England, France, Germany, Switzerland, Holland, Spain, Portugal, Taiwan, China [mainland and Hong Kong], Australia, Brazil, Mexico, Canada, France, Italy, and Japan.
Thank you for any help. -- Kamaluokeakua
> For example I don't want to force users to enter a phone number with a mask of (999) 999-9999 if they are in a country that doesn't have that format. Or force the entry of a SSN when the country utilizes a different format than 999-99-9999.
For some fields you formats available in .NET (dat, time, currency).
For the others, provide a way to make them accessible for localization.
Regular expressions in the resouces can be quite flexible for fields
validation. Some kind of "format descriptors" can be used for display.
And a wasy to specify field order and which fields are mandatory can
be developed for addresses. There is nothing standard in the .Net or
Windows API.
You should also be aware that there are countries that have nothing
like SSN (or personal ID, or whatever)
--
Mihai
-------------------------
Replace _year_ with _ to get the real email
Mihai,
This application is actually a local app (US) that is only operating in the
US. The issue I am running into is storing information regarding investors
abroad. For example if they invest in my fund I have to store information
such as their address, phone number, etc. So when communicating with them I
have the proper format for sending mail, calling them etc. They aren't
actually entering the information themselves but receive reports from our
server and the reports must be mailed out to each investor. Formats for
sending mail locally (US) are different than say Germany or England. So I am
looking to make the application more intuitive when entering data. Like when
they select the US it fills out the states combo box with all of the states,
if they select England it fills the region combo box with each region, etc.
When they want to enter a phone number in the US it gives them a mask that is
widely acceptable for phone numbers e.g. (999) 999-9999. Not many other
contries utilize this format so I want it to automatically create the mask by
determining the country's format. The issue that I run into is not knowing
what each country's framework for these fields is. I was looking more for a
direction on someone who has already dealt with this and where they obtained
their information from.
Thanks again,
Kamaluokeakua
"Mihai N." wrote: For example I don't want to force users to enter a phone number with a mask of (999) 999-9999 if they are in a country that doesn't have that format. Or force the entry of a SSN when the country utilizes a different format than 999-99-9999. For some fields you formats available in .NET (dat, time, currency). For the others, provide a way to make them accessible for localization. Regular expressions in the resouces can be quite flexible for fields validation. Some kind of "format descriptors" can be used for display. And a wasy to specify field order and which fields are mandatory can be developed for addresses. There is nothing standard in the .Net or Windows API. You should also be aware that there are countries that have nothing like SSN (or personal ID, or whatever)
-- Mihai ------------------------- Replace _year_ with _ to get the real email
I have seen a site on the net which detailed loads of the formats, as
regular expressions, IIRC. A Google for address regex might get you
somewhere.
All the Best
Julian N.
"Kamaluokea kua" <Ka***********@ discussions.mic rosoft.com> wrote in message
news:F9******** *************** ***********@mic rosoft.com... Mihai,
This application is actually a local app (US) that is only operating in
the US. The issue I am running into is storing information regarding
investors abroad. For example if they invest in my fund I have to store information such as their address, phone number, etc. So when communicating with them
I have the proper format for sending mail, calling them etc. They aren't actually entering the information themselves but receive reports from our server and the reports must be mailed out to each investor. Formats for sending mail locally (US) are different than say Germany or England. So I
am looking to make the application more intuitive when entering data. Like
when they select the US it fills out the states combo box with all of the
states, if they select England it fills the region combo box with each region,
etc. When they want to enter a phone number in the US it gives them a mask that
is widely acceptable for phone numbers e.g. (999) 999-9999. Not many other contries utilize this format so I want it to automatically create the mask
by determining the country's format. The issue that I run into is not
knowing what each country's framework for these fields is. I was looking more for
a direction on someone who has already dealt with this and where they
obtained their information from.
Thanks again,
Kamaluokeakua
"Mihai N." wrote:
For example I don't want to force users to enter a phone number with a mask of (999) 999-9999 if they are in a country that doesn't have that format. Or force the entry of a SSN
when the country utilizes a different format than 999-99-9999. For some fields you formats available in .NET (dat, time, currency). For the others, provide a way to make them accessible for localization. Regular expressions in the resouces can be quite flexible for fields validation. Some kind of "format descriptors" can be used for display. And a wasy to specify field order and which fields are mandatory can be developed for addresses. There is nothing standard in the .Net or Windows API. You should also be aware that there are countries that have nothing like SSN (or personal ID, or whatever)
-- Mihai ------------------------- Replace _year_ with _ to get the real email
Thanks Julian, I couldn't find anything on mailing address formats using the
address regex on google. Mostly email and IP address regex only.
"Julian Nicholls" wrote: I have seen a site on the net which detailed loads of the formats, as regular expressions, IIRC. A Google for address regex might get you somewhere.
All the Best Julian N.
"Kamaluokea kua" <Ka***********@ discussions.mic rosoft.com> wrote in message news:F9******** *************** ***********@mic rosoft.com... Mihai,
This application is actually a local app (US) that is only operating in the US. The issue I am running into is storing information regarding investors abroad. For example if they invest in my fund I have to store information such as their address, phone number, etc. So when communicating with them I have the proper format for sending mail, calling them etc. They aren't actually entering the information themselves but receive reports from our server and the reports must be mailed out to each investor. Formats for sending mail locally (US) are different than say Germany or England. So I am looking to make the application more intuitive when entering data. Like when they select the US it fills out the states combo box with all of the states, if they select England it fills the region combo box with each region, etc. When they want to enter a phone number in the US it gives them a mask that is widely acceptable for phone numbers e.g. (999) 999-9999. Not many other contries utilize this format so I want it to automatically create the mask by determining the country's format. The issue that I run into is not knowing what each country's framework for these fields is. I was looking more for a direction on someone who has already dealt with this and where they obtained their information from.
Thanks again,
Kamaluokeakua
"Mihai N." wrote:
> For example I don't want to force users > to enter a phone number with a mask of (999) 999-9999 if they are in a > country that doesn't have that format. Or force the entry of a SSN when > the country utilizes a different format than 999-99-9999. For some fields you formats available in .NET (dat, time, currency). For the others, provide a way to make them accessible for localization. Regular expressions in the resouces can be quite flexible for fields validation. Some kind of "format descriptors" can be used for display. And a wasy to specify field order and which fields are mandatory can be developed for addresses. There is nothing standard in the .Net or Windows API. You should also be aware that there are countries that have nothing like SSN (or personal ID, or whatever)
-- Mihai ------------------------- Replace _year_ with _ to get the real email This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Privacy Advocate |
last post by:
//crossposted to: comp.lang.javascript, alt.comp.lang.javascript in an
effort to get factual answers from JavaScript experts//
Simply put; Is it possible to obtain the real (actual) IP address of
someone (client) that visits a web site through an anonymous proxy if
this person ONLY has JavaScript enabled in their browser? This is NOT
a question about PHP, perl, VBScript, Java(.class), or ActiveX. Let us
_only_ deal with JavaScript for...
|
by: DerekM |
last post by:
I have a database project that I created with several forms and
reports. I would like to be able to declare a single title and be
able to change the title on all the forms and reports by changing a
single variable. I think this is possible, however I don't know
Visual Basic very well. I created a module named DBcommon with the
following statements in it:
Option Compare Database
Global Const DBname As String = "Title String"
|
by: Srinivas Kollipara |
last post by:
Hey guys,
i have a small question in C#. I have a windows form which has Address
fields, zip code and phone number fields. it is working fine with U.S. but i
need to modify that for all the other countries. is there any way i can
validate zipcode and phone numbers.... Thanks in advance.
bye
Srinivas
|
by: wh |
last post by:
The application that I'm about to start working on requires maintaining a
list of users currently accessing an asp.net application running on IIS5.0.
I essentially need to monitor which xml files on the server various users
are working on. When a user selects an xml file, it is marked as 'locked'
thus disallowing other users from modifying it. The users will come and go
and I therefore need to remove the 'locked' flag from the respective...
|
by: Kevin Newman |
last post by:
Does anyone know of any application (AJAX or other) that will display
the appropriate address for for the selected (or detected) country?
If not, does anyone know where I can find a list or database of address
formats, so that I can make a collection of xml files (or php and/or
javascript classes) that represent the address format for each country,
so that I can display the correct form elements for a user's own country?
I'd really...
| |
by: Egil Helland |
last post by:
Hi,
I am creating a list of phone numbers, and would like to have a feature
similar to the address book in OS X - that is, when you click on a phone
number, a semitranclusent, large banner appears with the phone number in
LARGE types. When it is clicked on, it should disappear again.
Is this possible to mimick with CSS and z-index? I think I have seen
this somewhere, but cannot recall where... Anyone able to point me in
the right...
|
by: Emily |
last post by:
Imagine a world where everybody shares and has faith in each other. We have
all struggled at one time or another with our jobs or careers and have
wondered if there was a better way to make a living. What if the solution
was just to help each other, simply by giving and receiving. This would be
a radical global experiment in faith. Imagine people all around the world
connecting instantaneously and just giving and receiving money to each...
|
by: alpana.dhole |
last post by:
I have made a ActiveX control for commericial application. A Drag and
Drop component for Mail server.
I need to host the component in Internet Explorer.
When a user opens a mail it should prompt the user to download and
register the Drag and Drop activeX component.
This should be a trivial program. Please let me know how is it done.
|
by: pythonnewb |
last post by:
I am fairly new to programming but have some very basic Java background. I am just learning python and tried to make a module that would allow me to create a file containing an address book. I was planning to then create a program to detect input and use this module, but I am hung up. I have constructed the code that I thought would work (though there may be a better way) and I got this error message. Traceback (most recent call last):
File...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |