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??
DateTimeEditor works with the DataTime data type, not a TimeSpan. For Timespan, you can use the new TimeSpanEditor as Amiram mentioned.
How I bind new UltraTimeSpanEditor 10.2 with database sqlce (sdf) ? What type of column should I use? nvarchar, datetime or other?
Sorry for my English. - Lello
According to this MSDN article, the SQL TIME datatype maps to a System.TimeSpan.
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?
Regards, Lello
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.
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?