.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Multi language database content

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :ASP.Net

The content of the web site I am creating is expected to store data for multiple languages.  What I mean by the content is the actual data stored in the database (SQL Server 2008 R2).  For example I have a database table to store available packages and one of the columns in this table is the description which is shown on the web site.  This description should be stored in multiple languages for example (en, fr, de).  

What is the best way(s) to get this done, I can of course have the same table with multiple columns (each column representing a single language) and code the data access layer to load the proper column based on the current language, but is there an easier way?  An ideal situation is where like in ASP.NET the database automatically detects the current language and return the proper column

View Complete Post

More Related Resource Links

Change Button Text in Multi Language Website


Hi i developing multi language website

using Master pages

everything fine

Page_Load i set the Text property of Button Control from Resource file

like this

Button1.Text = GetLocalResourceObject("Button1")

then in the button click event i cnage the text of the Button control

Button1.Text = GetLocalResourceObject("Button1_new")

but the text doesn't change and no error messgae

what is the problem how to solve this


For Multi-Language website which process is better in asp.net


 I want to build multi-language website in asp.net 2008 and asp.net 2010. So, which process is better for building application? Using either Local and Global Resource or New Folder to make separate according to language?


Application performance should be good and also easy manageable.


Please suggest me in which way I will build the application either using resource or folder. If there is any other better solution then please share.

How to get access to content database after server hardware failure


Sharepoint server 2007 and remote sql 2000 SP4 database, after ShraPoint server crash only content databases are available and intact. Trying to restore from backup fail, stsadm -o restore says that not valid backup is available on path. How to get access to available content database using a new installation with same server name, ip address and partitions configuration. How to recover site with content databases information.

Regards, thanks for help.

Victor Naranjo MCSE + Security MCSA + Security MCSE + Messaging MCSA + Messaging ITIL Certified Comptia Security+

MOSS Content Database has more documents than what's seen on browser

I am not sure how sharepoint internally handles stuff, but this is what I see. I am a SQLDBA and one of my company sharepoint group re-organized a site, by moving some files from a document library to another document library. I think she used the content deployment.

When she see the number of documents in the document library it showed 700 documents. She moved only 50 of them. I went into the database and queried the Docs and DocStreams View and I get the list of all the those documents. I see both the ones that we see on the site as well as something that we do not see on the site.


ad.DirName, ad.LeafName, TimeCreated, ads.size/1024 as [Size(KB)], SetupPath

FROM Docs ad, DocStr

Estimate weight of BLOB data in our content database

How can I estimate overall size of blob data?

Unable to install SP3 on SQL 2005 due to Database Services language being blank

Hi all,   I have an issue that requires me to upgrade to a later SP (currently on RTM), but when I try to install SP3 Database Services cannot be ticked. Upon inspection I see that its reporting "This update requires language ENU.  The language for this product instance MSSQLSERVER is . Download the upadte for langage .", when I check teh Language field to the right it is blank, other parts however are fine and can be upgraded. Can you advise please as I don't know how to manually set the language (which is reported inside SQL itself as English (United Kingdom)) and I cannot un/reinstall. Thanks, John

Search content of different languages in one language of MOSS

Hi, Hope you guys can help to answer this Search question. E.g. English MOSS is installed, content in English, Traditional Chinese, Simplified Chinese and Japanese are input to the system (either in Word/Excel file, ASPX page, Blog entry or Wikis page). In this case, how can the user search content by entering search keywords in languages other than English? The reason I ask this question is that: MOSS Search Engine uses English work-breaker/stemmer in the crawling and query process in MOSS English Version. Then, it cannot distinguish which languages are being crawled, e.g. pretending Japanese and Chinese as English when crawling the content. Is there any advanced way to solve this issue in MOSS 2007, besides installing various languages of MOSS in different servers? This problem exists in SharePoint 2003, so now I wonder if there is any improvement in 2007. As you know this is especially important in HK environment. Every customer ask the same question in Pre-Sales demo. Thanks in advance. Paul

SharePoint Version 2.0 (WSS 2.0 SP3) Content Database restore to new farm

Is it possible to use an SQL backup from a sharepoint Version 2 SP3 database to restore the content on a new server farm and attach to a new web applicaiton. NOTE: This is WSS 2.0. In WSS 3.0 this is a very simple task, but it is not the same in WSS 2.0 (the add content database option CANNOT be used to attach to an existing content database like it does in WSS 3.0). The options I have found appear to say you need the configuration database from the old server then it can be done. I am migrating from an outsourced deployment, so I do not have access to that. Plan B is to do a sharepoint STSADM backup. THis seems to be a more likey way to do it.

Questions on Multi-Tenant Data Architecture for SQL Server Database and ASP.NET application

My company wants me to make the same asp.net application and sql server database be sharable amongst different clients. Clients will use the database for their own business use, will have their own data, we will have our own data. How can I share the same SQL Server database amongst different clients having same ASP.NET application (but somehow be able to differentiate which client user is logging in) ? Do I need to use ApplicationID and how will I detect at login which one to use ? I know I will need to add another field in all tables to differentiate client's data from ours.  

Cannot create content database: The specified SPConfigurationDatabase Name=SharePoint_Config Parent=

Guys, This is the farm configuration: 1. SQL Server 2005 back end server 2. WSS 3.0 / MOSS 2007 WFE Server 3. WSS 3.0 / MOSS 2007 Index/WFE Server All servers are showing the version: in 'Servers in Farm' in C.A. When attempting to add a new content database, the following error is thrown in the web UI: The specified SPConfigurationDatabase Name=SharePoint_Config-New Parent=SPDatabaseServiceInstance has been upgraded to a newer version of SharePoint. Please upgrade this SharePoint application server before attempting to access this object. Furthermore the following is posted to the application event log on the WFE hosting central admin: Database 'SharePoint_Config-New' on SQL Server instance 'XXXXXXXX' is not empty and does not match current database schema. There is nothing of further interest in the trace log, just the same error as above. No errors on the SQL server either. Also no updates have been installed, and content databases HAVE been created since the last updates were installed 2 years ago. Can anyone suggest anything before I raise a call with MS? I have checked permissions for the sharepoint system account on the databases and all seems fine. Cheers, Conrad    Conrad Goodman MCITP SA / MCTS: WSS3.0 + MOSS2007

How to get previous version of content database

Hi,   Setps I did.... 1. Created Site collection with url http://server.80/Site1 2. taken the back up of dev server site collection and trying to restore with this new site collection 3. But, i restored in http://server.80/ How to get the content databse back up of http://server.80/  Pls its very urgent......................   Thanks in Adv..................

Multi language in SSRS

hi all ,I'm a software manager that want to select a Reporting engine and develop international application , i want to know Dose SSRS support multi-languages environments(Special in Report Builder for end users) or not ? and if yes , how? thanks

Content Database Purge ?

  I just made an experiment: created new web app created new site collection put there a doclib1 with 5 Gb of pdf documents checked size of content db in sql studio - it was 5.5 Gb with 300 Mb available (free, but reserved space, that can be redeemed with shrink operation) Then i deleted doclib1 Then i cleaned recycle bin (2 level), so on this stage the data is totally deleted on site level with no restoration options Checked the db - 5.5 Gb (which is normal) with 800 Mb available. Why 800 Mb and not 5 Gb ? Why i can redeem only 500 Mb in the end ? Are sharepoint content dbs are even made for redeeming space after some of its contents are deleted ?

after restoring content database getting error (HTTP/1.1 200 OK Server: Microsoft-IIS/7.5 Date: Tue,

Hi All, Problem i have taken backup of Old site content database procedure see below 1) first i changed the database to read only mode (Opened SQL Server2005-->selected DB--> properties--> Option-->Database Read-Only=True) 2) taken backup of database from the task--Backup(new.bak) 3) Copied the taken backup to new server and restored (Opened SQL Server2005 --> Right Click on Database Folder--> Restore Dataase) In To database: ihave given DB name From Device: i have selected database from the location where i have saved. click ok.  It has restored successfully 4) I have created a new webapplication and removed its content database from central admin. 5) with the help of stsadm command i restored the above db to this webapplication. then iam getting below error: HTTP/1.1 404 Connection: close Date: Tue, 14 Sep 2010 06:20:08 GMT Server: Microsoft-IIS/6.0 X-Powered-By: ASP.NET MicrosoftSharePointTeamServices: i have refered the below url for restoring http://metahat.blogspot.com/2008/11/backup-restoring-sharepoint-2007-site.html Please help. Thanks in advance.

Database design for treeview and content

HiI"m student and need help to design a database for treeview and some content.I need a database design with treeview and it's childnodes,  different content for each node, and modules for each page, like search, contact form and etc... with ability to turn it on and off.Maybe you can show me the way or maybe you have some good links for database design. Any help would be appreciated.THANKS

Powerhsell script for MOSS 2007 to get content database size



Can you please provide me a script to get content database size in MOSS 2007.




After adding the content database, i could see the Current Number of Sites are zero.


After adding the content database, i could see the Current Number of Sites are zero.

Its should be 5, but its hsowing me 0,

what i need to do for this 

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend