.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

Change Regional Settings

Posted By:      Posted Date: September 07, 2010    Points: 0   Category :SharePoint
I need to change regional settings on SharePoint so that the date format is not mm/dd/yyyy but dd/mm/yyyy.I have seen that this can take place if i go to Home site->Site Settings->Regional Settings and change the locale from there. All are perfect up to here. Since i need this change to take effect on subsites as well I check the "All sub-sites inherit these Regional Settings". After Pressing ok, i get an error message "Please turn off all indexed columns before changing the collation of this site. One or more list or library contains a column that has been marked for indexing. ..."How can i stop this indexing temporary? i tried to stop the indexing service from service administration but this didn't work.After applying this change, i hope my dates will not be lost, correct (this is the production server.....)? Will i have any problem with the search? Do i need further actions?a.rongas

View Complete Post

More Related Resource Links

Regional settings (locale) in SP - is there any way to change that settings? eg. date format

The system I use is MOSS2007. I have regional settings set to "Polish". The default date format is yyyy-mm-dd, what is wrong because usually is dd-mm-yyyy. Is there any way to change specific regional settings? I couldn't have found it on internet. I've tried to change to "French", which gives me dd-mm-yyyy, but then eg. in calendar I have days and months in French language :)

Convert English to Arabic number without changing any regional settings in .net

Well, most applications that I worked with was multilingual that supports English UI and Arabic UI.

And one of the major issue that we have faced is displaying Arabic numbers without the need of changing the regional settings of the PC.

So the code below will help you to display Arabic number without changing any regional settings.

Dynamic list item title based on date created & regional settings?

I have a list of things that doesn't *need* a title.  However, because sharepoint uses Title for links, RSS etc  I tried generating a title in an event handler.   This would work great if I wasn't basing it on a date field: public override void ItemAdding(SPItemEventProperties properties) { DateTime dt = Convert.ToDateTime(properties.AfterProperties["TestDate"]); properties.AfterProperties["Title"] = dt.ToShortDateString(); base.ItemAdding(properties); } In testing, this sets the title to "8/9/2010" when I selected 8/10/2010 in the date picker.  I figure this is because of the regional settings of my test user.  I can probably correct the title value for 'test user' but that won't fix 'test user in mongolia' who would still see two different values. So What I would like is to have the Title always display the value MyDate in the uesr's locale.  So the field needs to be dynamic not only at edit/update time, but at display time. Does anybody know if this can be accomplished, and more specifically how?

How do I change the top menu navigation for layouts like Site Settings?

I used something similiar to what Kalik posted on this thread, however, I'm not seeing the same results in layouts like Site Settings.  Any answers would be appreciated. Thank you, Mike ADD TO TOP LINE! <%@ Register Tagprefix="PublishingNavigation" Namespace="Microsoft.SharePoint.Publishing.Navigation" Assembly="Microsoft.SharePoint.Publishing, Version=, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %> ADD IN HEADER AREA! <PublishingNavigation:PortalSiteMapDataSource ID="siteMapDataSource1" runat="server" SiteMapProvider="CombinedNavSiteMapProvider" EnableViewState="true" StartFromCurrentNode="true" StartingNodeOffset="0" ShowStartingNode="false" TreatStartingNodeAsCurrent="true" TrimNonCurrentTypes="Heading"/> </HEAD> REPLACE STANDARD TOP NAV CODE! <!--- Modified Top Nav ---->    <SharePoint:aspmenu    ID="GlobalNav"    Runat="server"    DataSourceID="siteMapDataSource1"    Orientation="Horizontal"     MaximumDynamicDisplayLevels="1"     StaticPopoutImageUrl="/_layouts/images/menudark.gif"    StaticSubMenuIndent="0px"  &nb

How programmatically change Additional Column Settings - Show field?


Hello. I use the SPFieldUser in my list. I can change Additional Column Settings - Show field: "Name with Presense" on the "Name (with Picture and details)" using the WSS Web interface. How do it programmatically, using Object Model WSS?

Handling regional language change


I have an application in which i need to know if the regional language of the system is changed or not.
Is there any event in WPF which will be fired when the user changes the language of the system?


Regional settings impacts Caml DateTime query



I am using the GetListItems web service to retrieve items from a list where my custom column UpdateCompleted is less than or equal to a given datetime. But, I noticed some weird behaviour of SharePoint 2007 going on. The query would perform differently when I changed my regional settings on the site settings page of SharePoint! When regional settings were set to UTC my query would select the items, when in GMT it would not.

I have specified my query to use a DateTime in UTC form (ends with Z) and I have also specified DateInUtc to TRUE in the query options. So I would expect SharePoint to do a UTC date compare despite what the site regional settings are set to.

This is my query:

<Query><Where><And><Eq><FieldRef Name='Status'></FieldRef><Value Type='Text'>Unlocked</Value></Eq><Leq><FieldRef Name='UpdateCompleted'></FieldRef><Value Type='DateTime' IncludeTimeValue='TRUE'>2010-10-08T18:40:21Z</Value></Leq></And></Where></Query>

This is my query options:

Using Custom Regional Settings in WPF


I am creating a localized WPF application and i want WPF to use whatever settings i have in my regional settings.

All over the internet they recommend the following code, which i did use

protected override void OnStartup(StartupEventArgs e)
    new FrameworkPropertyMetadata(

Now, let's suppose that in the regional settings i'm still using en-US but i have decided to show the currency as 1 digit after the decimal point instead of 2

If i use this code, it works perfectly

decimal d = 2.5M;

but when i use binding, i still get both digits after the decimal point


My regional Settings


On our Project 2010 site only users with contribute permissions have the option to change their regional setting through the users My Settings properties , but users with more restrictive  access to the site do not see the option to change their My regional settings . They only see the My Alerts . is there a way to enable this for all users ?

Forms Services Regional Settings


When a user selects a date with the Date Picker control, the date is entered as mm/dd/yy. In Australia we use a slightly reversed date format to the default US setting: dd/mm/yy.

I have checked the regional settings in the following placed, but they're all set to Australia:
1. The SharePoint site that's hosting my form (i.e. the list that has my form as a content type).
2. The SharePoint front-end web server that's hosting the SharePoint web application.
3. My local PC.

Is there some other place I need to set the region?



Display an SSRS Report in multiple (user's) regional settings



I have an SSRS Report that I've developed that returns date values. I have users that will access this report globally, and I would prefer that the report return these dates in the format tied to their regional settings.

I have set the RDL Language property to the expression =User!Language. this works on my local development environment.

Then I published to my ReportServer (MOSS 2007). Now no matter what regional settings my PC is tied to, both the report paramters and date format display in whatever Regional setting my SharePoint site is set to.

Is there a way that I can dynamically display the report using the User's regional settings?


How to change the URL in Search Settings to use Custom Scopes.



How can I change programmatically the URL for the Custom Scopes?

It's in the Administration -> "Search Settings".



SP2007 Area Navigation Settings - Any Change cause an Unknown Error



We have an issue with SP2007, when we modify the navigation for one subsite and attempt to save the changes by clicking ok we get an 'Error' page with a description of Unknown Error.

All we are changing is either the order or deleting a heading with a URL attached.

Saving the changes takes roughly 5 minutes to complete and is not immediate.


Any help would be greatly appreciated, thank you.

How to Localize Windows Forms and Change the Language at Runtime

Localization is the process of customizing your application to a particular language, culture or locale. Visual Studio provides support for localizing Windows Forms with much ease. In this article, we will see how to localize windows forms and give the user the ability to change to his preferred language at runtime.
When you run a localized application, the appearance is determined by two culture values. The UICulture property is used to specify which resource files will be loaded for the form. The Culture property, on the other hand, determines how strings such as dates, numerals, and currency amounts are formatted.
Let us see the steps required to create a localized form. You can then expand this example and adopt the same approach for the rest of the forms in your project

validateRequest appears to be kicking in in MVC RC1 despite settings

After upgrading a project to the RC a System.Web.HttpRequestValidationException is thrown when posting a value containing HTML from a TextArea. I have checked that validateRequest=false in Views/web.config, and have set this in the application's root web.config. I have also created a fresh MVC project, created a simple view & controller and posted a simple html paragraph element with the same result. Call stack provided. [HttpRequestValidationException (0x80004005): A potentially dangerous Request.Form value was detected from the client (html="

hello world

").] System.Web.HttpRequest.ValidateString(String s, String valueName, String collectionName) +8718538 System.Web.HttpRequest.ValidateNameValueCollection(NameValueCollection nvc, String collectionName) +111 System.Web.HttpRequest.get_Form() +129 System.Web.HttpRequestWrapper.get_Form() +11 System.Web.Mvc.ValueProviderDictionary.PopulateDictionary() +113 System.Web.Mvc.ValueProviderDictionary..ctor(ControllerContext controllerContext) +74 System.Web.Mvc.ControllerBase.get_ValueProvider() +31 System.Web.Mvc.ControllerActionInvoker.GetParameterValue(ControllerContext controllerContext, ParameterDescriptor parameterDescriptor) +53 System.Web.Mvc.ControllerActionInvoker.GetParameterValues(ControllerContext controllerContext, ActionDescriptor actionDescriptor) +109 System.W

Selected to change the background color of the page



As this site, http://www.borfin.com.tr/genel/Default.aspx, How can I change the background color selected pages.

Bug: Does not change column type from nvarchar to ntext


Scenario: If you create a table with a column of type nvarchar, populate it with some content and try to modify it using the WebMatrix editor, from nvarchar to ntext, it does not display any error message or warning that this is not possible. It silently saves and reverts the change, back to nvarchar. Wasted some hours on this issue as I thought my column was ntext, but in fact was still nvarchar.

Expected behavior: It should change to ntext, or if SQL CE doesn't support that, it should notify the user that no change was applied.

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