DataTable.Locale Property
.NET Framework (current version)
Gets or sets the locale information used to compare strings within the table.
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 Sub ChangeCultureInfo(table As DataTable) ' Print the LCID of the present CultureInfo. Console.WriteLine(table.Locale.LCID) ' Create a new CultureInfo for the United Kingdom. Dim myCultureInfo As CultureInfo = New CultureInfo("en-gb") table.Locale = myCultureInfo ' Print the new LCID. Console.WriteLine(table.Locale.LCID) End Sub
.NET Framework
Available since 1.1
Available since 1.1
Show:
