Hi,
I am trying to bind UltraDateTimeEditor with timespan value at that time i can't bind this value. Even Default value is also not set to this control.
I am using code for binding :
*****************************************************************************
.Name =
"dtpDefaultDate"
.DisplayStyle = EmbeddableElementDisplayStyle.Office2007
.DropDownButtonDisplayStyle = Infragistics.Win.ButtonDisplayStyle.Never
.SpinButtonDisplayStyle = Infragistics.Win.ButtonDisplayStyle.Always
.MaskInput =
"{time}"
.DataBindings.Add(
"Value", datDocs.Tables("docs"), "timeValue", True)
End With
At that time not getting error but value is also not binded.
Any solution regarding this issue??
Dear support,
Microsoft SQL Compact Edition does not support System.TimeSpan datatype
Your UltraTimeSpanEditor has two properties (Databindings) : "Tag" and "Value".It needs a property (Databindings) "Text", which Get or Returns a TimeSpan in text format.
Regards, Lello
Hi All,
I still have the same problem.SqlCe does not support System.TimeSpan datatype (read above). How I bind new UltraTimeSpanEditor 10.2 with database sqlce (sdf) ? Can anyone help me?
Can I solve this problem by using a filter?
Dear Brian,
Unfortunately SqlCe does not support System.TimeSpan datatype. Read this MSDN article: http://msdn.microsoft.com/en-us/library/aa237850(SQL.80).aspx
I tried using nvarchar(16), but the value of the column nvarchar "2.00:00:00" is converted your control in "00:00:00" (instead of 2 days). You can suggest me another way to bind new UltraTimeSpanEditor 10.2 with database Microsoft SQL Compact Edition?
According to this MSDN article, the SQL TIME datatype maps to a System.TimeSpan.