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 )