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 3494
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
"Kamaluokeakua" 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.
"Kamaluokeakua" <Ka***********@discussions.microsoft.com> wrote in message
news:F9**********************************@microsof t.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.
"Kamaluokeakua" <Ka***********@discussions.microsoft.com> wrote in message news:F9**********************************@microsof t.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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
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,...
|
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,...
|
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...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
| |