I recently updated my PhotoGallery sample code that illustrates many techniques including:

• The use of profiles that store preferred theme and culture
• Dynamic theme selection at runtime based on profile settings
• The use of ASP.NET 2.0 localization features
• Setting the request thread's culture dynamically based on profile settings
• Database localization (table selection by culture)
• Caching by culture and theme
• Workaround for retrieving profile information for custom caching (GetVaryByCustomString())

The sample update is at this link: http://www.dasblonde.net/downloads/VS2005/Globalization/GalleryDemo20.zip

These features were always in the sample, but I came up with some improvements for caching and profiles, and I updated the sample so that all pages cache appropriately. I also created a full SQL script that would create the database and insert records, so that you no longer have to restore a full databas to create those records. Otherwise the sample is much the same. Enjoy!