DataTable.Locale Property
Gets or sets the locale information used to compare strings within the table.
Namespace: System.Data
Assembly: System.Data (in System.Data.dll)
Property Value
Type: System.Globalization.CultureInfoA CultureInfo that contains data about the user's machine locale. The default is the DataSet object's CultureInfo (returned by the Locale property) to which the DataTable belongs; if the table doesn't belong to a DataSet, the default is the current system CultureInfo.
A CultureInfo represents the software preferences of a particular culture or community.
When used for string comparisons, the CultureInfo affects sorting, comparisons, and filtering.
 Note |
|---|
In columns that contain expressions, the InvariantCulture is used. The CurrentCulture is ignored. |
The following example sets the CultureInfo through the Locale and prints the ISO language name.
private void ChangeCultureInfo(DataTable table) { // Print the LCID of the present CultureInfo. Console.WriteLine(table.Locale.LCID); // Create a new CultureInfo for the United Kingdom. CultureInfo myCultureInfo = new CultureInfo("en-gb"); table.Locale = myCultureInfo; // Print the new LCID. Console.WriteLine(table.Locale.LCID); }
Windows 8, Windows Server 2012, Windows 7, Windows Vista SP2, Windows Server 2008 (Server Core Role not supported), Windows Server 2008 R2 (Server Core Role supported with SP1 or later; Itanium not supported)
The .NET Framework does not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.
