A
Alex
Hi,
We're working on what will become a multi-language application, and I
wanted to see if this idea is feasable.
What we're thinking of doing is creating a table to contain all text
of the application and in multiple languages, for example:
Col1 - ID
Col2 - English
Col3 - French
Col4 - Spanish
When the application launches the user selects a language, and both
English and their chosen language will be loaded into a Dictionary in
memory. Then at the Form Load event for each form that loads, it'll
loop through all labels and buttons on the form, search the dictionary
for the given text, which is English, and replace it with the
alternative language text.
For dropdowns being populated by a look-up table, if these are saved
as a dictionary in of themselves, the look-up dictionary could then be
compared to the language dictionary and translated at Form Load as
well.
This is all in theory, but will this work? Also what caveats are we
looking at? I figure if the language dictionary is loaded when the
application launches there won't be too many DB calls.
Thanks --
Alex
We're working on what will become a multi-language application, and I
wanted to see if this idea is feasable.
What we're thinking of doing is creating a table to contain all text
of the application and in multiple languages, for example:
Col1 - ID
Col2 - English
Col3 - French
Col4 - Spanish
When the application launches the user selects a language, and both
English and their chosen language will be loaded into a Dictionary in
memory. Then at the Form Load event for each form that loads, it'll
loop through all labels and buttons on the form, search the dictionary
for the given text, which is English, and replace it with the
alternative language text.
For dropdowns being populated by a look-up table, if these are saved
as a dictionary in of themselves, the look-up dictionary could then be
compared to the language dictionary and translated at Form Load as
well.
This is all in theory, but will this work? Also what caveats are we
looking at? I figure if the language dictionary is loaded when the
application launches there won't be too many DB calls.
Thanks --
Alex