Hello all,

We have a DataSet bound to a DataGrid, this DataSet has a datetime column, coming from SQL Server.

We want to show this field on the DataGrid always as "DD/MM/YYYY", ignoring user's regional configuration.

For example if the user has the date regional configuration as "DD*MM*YYYY" (with stars), the DataGridTextBoxColumn shows the date as "DD*MM*YYYY" even if our code is:

DataGridTextBoxColumn oTextBoxNatural = new DataGridTextBoxColumn();
oTextBoxNatural.MappingName = "datetime_field";
oTextBoxNatural.HeaderText = "Show date as DD/MM/YYYY";
oTextBox.Format = "dd/MM/yyyy";
oTextBoxNatural.Width = 100;
dty.GridColumnStyles.Add(oTextBoxNatural);

How can we show the date always as "DD/MM/YYYY"? We do not want to depend on user's regional configuration since in our environment each user configurates this as they want.

Thanks a lot.