Datagrid and sql datetime in multiple langauge

EDN Admin

EDN Admin

Well-known member
Joined
Aug 7, 2010
Messages
12,794
Location
In the Machine
I have a datagrid which is being populated from a sql source. The problem I have is the sql server has a regional language settings of English (United Kingdom) but some of the clients are setup as English (United States). All fields within the datagrid know they are a DateTime format and when UK region is selected, everything is fine. Unfortunatly when the client is under a US region, an exception is thrown relating to the translation of the DataTime parameter. How do I get the datagrid to accept this alternative format of datatime entry and still use datagrid.datasource ?

// For example
DataTable table;
datagrid.datasource = table;

Thank you for any solution




View the full article
 
Back
Top