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
JS
Jeba S
Syncfusion Team
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.
MB
Manoj Bhaskarakurup
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.
MB
Manoj Bhaskarakurup
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
JS
Jeba S
Syncfusion Team
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.