Last post Jul 27, 2010 11:19 AM by ankur.nigam
Jul 22, 2010 05:43 AM|Shreshtha|LINK
How can I localize data, which is populating from database..
Jul 22, 2010 06:44 AM|Tapan Bhatt|LINK
Below post will helpful to you:
Jul 22, 2010 08:30 AM|Shreshtha|LINK
Thanks, but it dint helped me.
Jul 23, 2010 03:07 AM|amodius|LINK
hi, i have the same problem,
now i am working to solve it
it is long to say "is done" , but my idea is insert :
oops, i found an exxample here: http://stackoverflow.com/questions/755384/asp-net-metaresourcekey
Jul 23, 2010 03:23 AM|amodius|LINK
oops, no sorry, i just tried it, and does not works
but i tried to do a function like <% translate(eval("title")) %>
end for each language the function returns the properly translation in the resource file
it seems working good now...
Jul 27, 2010 11:19 AM|ankur.nigam|LINK
If I understand you requirement correctly from such a breif statement, it basically depends on what you have in your database.
For instance, if you have a field, say "About" in one of the table. One of the record(s) in the table says "I am new to this collage" for "About" field and you would like it to be automatically changed to its other culture equivalent like Spanish/Russian
then its not possible.
If you want to convert "I am new to this collage" to some other language, then you need to do it manually. There is no possible way to accomplish it via database technology.
Only possible alternative(s) is that you can convert it to other culture and save it in database beforehand. Thereafter, when required, you can retrieve it from database and render it on page for correct culture.
Alternatively, you can use Language translation APIs like Google Language to populate the information in specific culture. To do it, you need to specify the desired culture for the page/application and populate the information on it in its native language
(English in our scenario.) Thereafter, on client side, you can invoke the Google Language Translation APIs to convert the specific text from English to specific language like Spanish/Russian etc. Thus the final output rendered to user would be in his (or specified)