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  |  

AspDotNetStoreFront
  Ads  
Active Modules -- Active Forums for DotNetNuke
 


  Sponsors  

Meet Our Sponsors

OnyakTech
The best choice for your web site host, email hosting, and domain registration.
CrystalTech Web Hosting™
Webhost4life, specialists in DNN hosting
Mad Development is a full service interactive agency focusing on the merge of design, technology, e-commerce, and affiliate marketing by providing total website solutions.
AspDotNetStoreFront - E-Commerce by Design - The Leading ASP.NET shopping cart platform for developers!
 


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.
 


MaximumASP
MaximumASP provides a wide array of web hosting plans to fit any hosting need. We also provide software and services needed to keep it running optimally.
MaximumASP.com 		Mad Development: dotnetnuke design and development
We are an expert Dotnetnuke shop specializing in developing solutions that merge the requirements of design and branding, content management, ecommerce, search engine optimization and business logic.
www.MadDevelopment.com 		telerik
telerik r.a.d.controls suite is the most innovative and comprehensive toolset for ASP.NET development, tailored for seamless integration with the DotNetNuke project. This integrated collection of controls allows professionals to build web-solutions with the UI richness and responsiveness of desktop applications.
dnn.telerik.com

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