I have an application (website) that I am developing. It is using ASP.Net 2005 and SQL Server 2005.

I need some advice on how to handle foreign language support. Eventually I want to let the user pick the language the site appears in (English, German, Spanish and french to start).

My database is is already using the nchar/nvarchar types. I may need them for future languages.

A lot of my content will be db driven, so that will be entered by the users. So I am all set on the foreign languages there. I need the buttons and navigation and such of the website to use the language chosen by the user.

What is the best way to set that up?

DB driven? Config files? language resource files? or what?

Any good tutorials or advice?