DataSet.xsd and Locale

29 Nov 2007 7:39 AM

Dimitris Milonas

Hello,

When I build a DataSet with the DataSet Designer (DataSet.xsd) every
DataTable has the property "Locale" which is set (I guess) to the current
collate of the table of the SQL Server (I'm using MSSQL). I want to build a
web application which is language neutral or translated in two or more
languages.
Is this property of the DataTable in the Designer going to be a problem? If
it is a problem, then how to overcome it?
At the beginning, I wrote "I guess" because I really don't where this locale
property came from? The MSSQL has collate sequence for "Latin1" for Western
European languages but in the DataSet Designer the "locale" property of the
DataTable doesn't have any value of "Latin1" instead it lists all the
different countries and languages.

Regards
Dimitris Milonas

29 Nov 2007 2:09 PM

Bryan Porter

Dimitris,

The DataTable Locale property contains a CultureInfo that describes how
strings should be compared within the table. When you begin to localize your
application, one of the things you would probably want to do is to set the
Locale property to the current users locale when you create an instance of
the object.

Here is the relevant documentation:

http://msdn2.microsoft.com/en-us/library/system.data.datatable.locale(VS.71).aspx

--
Regards,

Bryan Porter
http://www.bryanporter.com/

"What A Horrible Night To Have A Curse!" - S. Belmont

Show quote

"Dimitris Milonas" <gn***@hotmail.com> wrote in message
news:%23d85QslMIHA.2208@TK2MSFTNGP06.phx.gbl...
> Hello,
>
> When I build a DataSet with the DataSet Designer (DataSet.xsd) every
> DataTable has the property "Locale" which is set (I guess) to the current
> collate of the table of the SQL Server (I'm using MSSQL). I want to build
> a web application which is language neutral or translated in two or more
> languages.
> Is this property of the DataTable in the Designer going to be a problem?
> If it is a problem, then how to overcome it?
> At the beginning, I wrote "I guess" because I really don't where this
> locale property came from? The MSSQL has collate sequence for "Latin1" for
> Western European languages but in the DataSet Designer the "locale"
> property of the DataTable doesn't have any value of "Latin1" instead it
> lists all the different countries and languages.
>
> Regards
> Dimitris Milonas
>
>