locked
Changing the culture of a data table. RRS feed

  • Question

  • User1637688157 posted

     Hi,

    I need to change the culture of my data table.

    I have a "createdOn" field in my data Table. Which contains the dateTime in EN-US Culture.

    but i want to make it in EN-GB CULTURE. 

    how will it be possible for all the data in that field of the data table using culture?

     

     

    Tuesday, May 22, 2007 2:12 AM

Answers

  • User-1506829456 posted

    Hi,

    To change the locale info of a column, you will have to change the locale info of the whole DataTable using DataTable.Locale Property.

    Here is an example

        CultureInfo myCultureInfo = new CultureInfo("en-gb");
        table.Locale = myCultureInfo;

    Please check the following link for more information:

    http://msdn.microsoft.com/en-us/library/system.data.datatable.locale.aspx

    HTH. If this does not answer your question, please feel free to mark the post as Not Answered and reply. Thank you!

     

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, May 24, 2007 1:57 AM