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.
Unfortunately, activation email could not send to your email. Please try again.

How can i validate a cell with time format in GridGroupingControl

Thread ID:





102080 Dec 21,2011 02:44 AM Dec 27,2011 06:35 AM Windows Forms 1
Tags: GridControl
Asked On December 21, 2011 02:44 AM

i use vb.net with sql server database.
i have a feild with type time(0) un sqlserver and i use it in GridGroupingControl.my problem is :
when i write a time like this in a cell with type time(0) --> 11:
an error raised wth this text.( 11: is not a valid value for TimeSpan)
how can i control he time that i entered in cell.


Kalaiarasan B [Syncfusion]
Replied On December 27, 2011 06:35 AM

Hi Shiva,

Thank you for your interest in Syncfusion products.

You can achieve your desired behavior in entering timevalue in a cell by using the following code

this.gridGroupingControl1.TableDescriptor.Columns[ColIndex/ColName].Appearance.AnyRecordFieldCell.CellValueType = typeof(DateTime);
this.gridGroupingControl1.TableDescriptor.Columns[ColIndex/ColName].Appearance.AnyRecordFieldCell.Format = "hh:mm";

Sample for your reference:


Please let us know if you have any other concerns



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.

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.