gridcontrol date format

[Smitha]

Hi,

I am working on this grid control. For displaying Datetime values, i want the datetime format to change as per the country.
Eg: India dd/mm/yyyy time: 24hr format
Us: mm/dd/yyyy time:24 hrs
So always the time is 24 hr format but the date formats are as per the country

Thanks
S

[Mercy C]

Hi Smitha,

Thanks for your interest in Syncfusion products.

please make use of "QueryCellFormattedText" event to set the format and culture.

 void gridControl1_QueryCellFormattedText(object sender, Syncfusion.Windows.Forms.Grid.GridCellTextEventArgs e)
        {
            if (e.Style.CellValueType == typeof(DateTime)) 
            {
                if (e.Value != null)
                {
                    e.Text = ((DateTime)e.Value).ToString("HH:mm:ss:ff", new CultureInfo("en-In"));
                    e.Handled = true;
                }
            }
        }

Please refer to the sample in the following link
http://www.syncfusion.com/downloads/Support/DirectTrac/92112/WindowsFormsApplication85-131721773.zip

Please let me know if you have any concerns.

Regards,
Mercy.C

[Smitha]

Thanks Mercy.

[Mercy C]

Hi Smitha,

Thanks for your update.

Please let me know if you have any concerns.

Regards,
Mercy.C