Hi all,

    Actually i am working on a project with SQL Server 2000 as Backend
and .Net as front-End.That Project is Completed and working well in Engish.I have to Enhance the Project those user select French the it should show in French.What are the modifications i have to do in Database to do this Task.
Please Guide me

Thanks,
Prabhakaran

you can to code your application as follows. Define the fields in your dot net that display on the screen as sourced from the database. For example if you want to say "first name" on your screen. Instead of doing what you normally would do which is put this in dot net. You need to setup some sort database table for this where you get all your description information from the database instead of dot net.
For example here is the high level of the logic. Person hits your front spash page. They select language = "french" you go to the database then to a table which has a value (database row) for each field you want to display in the dot net front end. For example you want your screen to say "login" and "userid" and "password". All of these three pieces of information are pulled from the database and then displayed on dot net. So if the person selected english previously they get one set of values, if they selected french they get another. A generic sample of of what this database would look like is this:

language table
1 english
2 french

Screen description table would be like this

Screen Field Languageid Description
------ ----- ---------- -----------
Login field42 1-English Login
Login field42 2-French Le Login
Login field43 1-English User Id
Login field43 2-French Utilisateur
Login field44 1-English Password
Login field44 2-French Mot de passe

Thanks a lot for your Reply

Thanks,
Prabhakaran

I am very happy to see you understand the reply. Also note its easy to add additional languages all through the database with now web code changes using this type of method.