how to translate dataset to some other language
i m building a multi-lingual website. static text i am translating using resource files. but dataset which i m to bind with dropdownlists, i don't know how to translate that. i have tried google transllate but it give me too many languages. i only need 3 or 4 langs. please help me 开发者_如何学Cin this regard
One standard practice is to have description tables including a language field
So if you now have
Products: ProductId, Description, Price, ...
You will have to change to 2 tables like
Products: ProductId, Price, ...
Description: ProductId, LangCode, Description
You can also have 1 translation table
Columns:
TableId (The table that needs translation)
FieldId (The field in the table, there can be more than one field that needs translation)
Language (The Language to translate into)
Key (The value of the primary key in the table )
Value (The translate value for field )
精彩评论