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
Can I solve this problem by using a filter?
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?
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.