<div>
That depends on your website nature<br />
<br />
If the words in the database are known in advance, then preparing a translation list and loading it into memory to used to perform translation would be a good thought.<br />
<br />
But if the words come from systems or users and you cannot predict them all, or you are dealing with text and phrases, then I think it would be better to save the data to a database for each language.<br />
<br />
I've been designing and working on a multilingual CMS for 4 months and it's comming out great, so if you need nay help on how to design your multilingual app, I'll be happy to help
</div>


That depends on your website nature

If the words in the database are known in advance, then preparing a translation list and loading it into memory to used to perform translation would be a good thought.

But if the words come from systems or users and you cannot predict them all, or you are dealing with text and phrases, then I think it would be better to save the data to a database for each language.

I've been designing and working on a multilingual CMS for 4 months and it's comming out great, so if you need nay help on how to design your multilingual app, I'll be happy to help

<div>
<div class="content wysiwyg-content">
Hello. I'm working on a website with Asp.Net/C#. I read data from my sql 2005 server tables and with this data I fill text fields and Drop Down List components. I would like to fill those dropdownlists and textfields with content varying with selected browser languages. I would begin with two languages.. english and italian for example. <br />
<br />
the question is: Should I build a multilanguage database somehow, or should I keep db in one language and translate everithing elsewhere before filling dropdownlist for ex. ?<br />
<br />
what do you think about it? and.. how do I do? :)<br />
<br />
thank you
</div>
</div>


Hello. I'm working on a website with Asp.Net/C#. I read data from my sql 2005 server tables and with this data I fill text fields and Drop Down List components. I would like to fill those dropdownlists and textfields with content varying with selected browser languages. I would begin with two languages.. english and italian for example. 

the question is: Should I build a multilanguage database somehow, or should I keep db in one language and translate everithing elsewhere before filling dropdownlist for ex. ?

what do you think about it? and.. how do I do? :)

thank you

Multilanguage Content

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications

ASP.NET

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).