Small width layout Medium width layout Maximum width layout Small text Medium text Large text
     Search
Downloads Downloads Directory Directory Forums Forums Forge Forge Blogs Blogs        Marketplace Marketplace Careers Program Careers
Community › Forums Register  |  

Maximum ASP
  Ads  
Aspose - The .NET & Java component publisher
 


  Sponsors  

Meet Our Sponsors

Portal Webhosting - Hosting For Developers
Red-Gate Software
MaximumASP
SourceGear - Tools for Developers
.: CounterSoft :.
telerik
 


DotNetNuke Forums
 
  Forum  DotNetNuke® Pro...  Language Packs ...  Localization of data in database
Previous Previous
 
Next Next
New Post 2/9/2007 12:49 AM
User is offline Paul Spann
11 posts
10th Ranked


Localization of data in database 

Hi,
i have a database with products in it. I want to display the product names in the correct locale. When in dnn dutch is selected i want to display the dutch name...etc. Im creating my own modules and I want to show all the product names in a dropdownbox. What changes do I have to make in my database? how does my control reckognise the selected locale? (I tryed to add a locale column to the db and when filling the dropdownbox adding     [locale] = @locale    to the stored procedure but that didnt work) 

If anyone could answer these questions or give me a good example id be very happy :)

Regards Paul
 
New Post 2/9/2007 8:12 AM
User is offline Mitch Sellers
5692 posts
www.mitchelsellers.com
3rd Ranked




Re: Localization of data in database 

One way of doing this is to create a name record for each of your products for each locale. You can then have a locale value in your table.

You can then use System.Threading.Thread.CurrentThread.CurrentCulture.Name to get the name of the current locale.  You then can run your query based on that.  I would reccomend in your stored procedure running the query and if nothing is found defaulting it to some language, just incase you don't have localized content for the specific language.

-Mitchel Sellers
MCITP, MCPD, MCTS
CEO/Director of Development - IowaComputerGurus Inc.
LinkedIn Profile

Visit mitchelsellers.com for my mostly DNN Blog and support forum.

Visit IowaComputerGurus.com for free DNN Modules, DNN Consulting Quotes, and DNN Technical Support Services

I reccomend 3Essentials for shared hosting and BaseCamp for project management
 
 Page 1 of 1
Previous Previous
 
Next Next
  Forum  DotNetNuke® Pro...  Language Packs ...  Localization of data in database
 


Forum Policy

These Discussion Forums are dedicated to the discussion of the DotNetNuke Web Application Framework.

For the benefit of the community and to protect the integrity of the project, please observe the following posting guidelines:

1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DotNetNuke.
2. Discussion or promotion of DotNetNuke product releases under a different brand name are strictly prohibited.
3. No Flaming or Trolling.
4. No Profanity, Racism, or Prejudice.
5. Site Moderators have the final word on approving/removing a thread or post or comment.
6. English language posting only, please.
 


DNNhost Scandinavia
SUPER fast QuadCore DELL servers, MSSQL servers, DotNetPanel, daily backup, Check out our customers websites
DNNhost.dk 		Personify Design, Inc.
Seattle-based Personify Design has developed customized DotNetNuke websites for a wide range of customers to meet many different types of needs, including distributed authorship across thousands of pages to integrated Verisign e-commerce capabilities.
www.personifydesign.com 		DNN Outsourcing
50% more affordable services comparing to Western Europe and US: Custom DotNetNuke module development, skins, consulting, maintainence... Over 15.000 working hours of experience in custom DotNetNuke Solutions development, 8 years experience in outsourcing, excellent references!
www.dnnoutsourcing.com

DotNetNuke Corporation   Terms Of Use  Privacy Statement
DotNetNuke®, DNN®, and the DotNetNuke logo are trademarks of DotNetNuke Corporation
Hosted by MaximumASP