We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on : Nov 16th 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

datetime formatting

Thread ID:

Created:

Updated:

Platform:

Replies:

59379 Apr 11,2007 11:22 PM UTC Apr 14,2007 04:08 AM UTC WinForms 4
loading
Tags: GridControl
Manoj Bhaskarakurup
Asked On April 11, 2007 11:22 PM UTC

Hi,

I have a gridGroupingControl which has a datetime column, I want the value to be displayed as Military time rather than with am and pm. Is there any property to do this.

Thanks
Manoj

Jeba S [Syncfusion]
Replied On April 12, 2007 10:03 AM UTC

Hi Manoj,

Please try this code snippet to format the datetime column in GridGroupingControl.

this.gridGroupingControl1.TableDescriptor.Columns["DateColumn"].Appearance.AnyRecordFieldCell.CellType="TextBox";;
this.gridGroupingControl1.TableDescriptor.Columns["DateColumn"].Appearance.AnyRecordFieldCell.CellValueType=typeof(DateTime);
this.gridGroupingControl1.TableDescriptor.Columns["DateColumn"].Appearance.AnyRecordFieldCell.Format = "MM/dd/yy HH:mm:ss:fff";

Kindly let us know if this helps.

Best Regards,
Jeba.

Manoj Bhaskarakurup
Replied On April 12, 2007 10:52 PM UTC

Hi,

The code did work, thanks for that. But the grid has become very slow in loading the data, performance is too bad. Anyway to improve performance?

Thanks
Manoj

>Hi Manoj,

Please try this code snippet to format the datetime column in GridGroupingControl.

this.gridGroupingControl1.TableDescriptor.Columns["DateColumn"].Appearance.AnyRecordFieldCell.CellType="TextBox";;
this.gridGroupingControl1.TableDescriptor.Columns["DateColumn"].Appearance.AnyRecordFieldCell.CellValueType=typeof(DateTime);
this.gridGroupingControl1.TableDescriptor.Columns["DateColumn"].Appearance.AnyRecordFieldCell.Format = "MM/dd/yy HH:mm:ss:fff";

Kindly let us know if this helps.

Best Regards,
Jeba.

Manoj Bhaskarakurup
Replied On April 13, 2007 10:52 PM UTC

Hi,

The code did work, thanks for that. But the grid has become very slow in loading the data, performance is too bad. Anyway to improve performance?

Thanks
Manoj

Jeba S [Syncfusion]
Replied On April 14, 2007 04:08 AM UTC

Hi Manoj,

I would like to mention that if your performance problems are related to initialization time of the grouping engine and loading data from a dataset, there are also some standard optimizations that let you speed up the grouping engine.

Please try this optimization settings and check if they make a difference.

gridGroupingControl.Engine.CounterLogic = EngineCounters.FilteredRecords;
gridGroupingControl.Engine.AllowedOptimizations = EngineOptimizations.DisableCounters| EngineOptimizations.RecordsAsDisplayElements;


Please refer the Performance Samples in the browser for more details:
C:\Program Files\Syncfusion\Essential Studio\4.4.0.51\windows\Grid.Grouping.Windows\Samples\PerformanceSamples

Kindly let us know if this helps.

Best Regards,
Jeba.

CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;