Hello,
I try to add a calendar control into UltraWinGrid cells who may contain some Nullable dates (Nullable(of Date) datatype) but the UltraWinGrid doesn't recognize the data in those cells as "Date" and the grid doesn't display the calendar as it should do by default for date datatype. So I've tried to add a UltraCalendarCombo he can't deal with Nullable datatype even if this control had a 'allowNull' property
I receive this error message : Editor provided by UltraCalendarCombo does not support the column's data type
Anyone know a control who may deal with Nullable dates (Nullable(of date)) and how to add it to an UltraWinGrid?
Thanks
After many hours of searchs and tests, We have found the solution. It's not a problem of version or hot fix, it's just a question of cell style.
When you set a cell to a nullable(of Date) or Nullable(of DateTime), you must set the style of the cell to force the grid to display the the calendar dropdown and format the content as a Date.
Here is the code to handle a Nullable Data datatype
e.Layout.Bands(1).Columns("column").Style = ColumnStyle.Date ' Set the style of the cell
e.Layout.Bands(1).Columns("column").NullText = "-" ' Display something when the date is set to Nothing
I've installed the version : 6.2.20062.1083 of the hot fix, (I know it's not the last one) and the problem still the same the grid still not be able to use Nullable(of date) even Nullable(of datetime)
I've made some tests with Date and DateTime datatype, I can set Date or datetime members of a class to Nothing (VB.NET) and the grid will be able to deal with those types and shows a calendar dropdown. The problem with that it's I'm not able to tell to the dropdown to not display the date "0001-01-01". I've set the "NullText" property of the cell to "-" and the property "Nullable" to "Nullable.Nothing" but the grid still to show "0001-01-01".
That is the original release version with no hot fix. You can find the hot fix versions listed here:
BLOGS: Vincent McDonald
And you can get the hot fixes for products you own here:
My Infragistics Keys and Downloads - Download Anything and Everything You Own
I'm not sure we use the latest hot fix. How can I see if it's installed (by the version number of the installed component?)
version used : 6.2.20062.34
One thing is sure, the grid detect Date datatype but he doesn't detect Nullable(Date) even Nullable(DateTime)
It sounds to me like you are experiencing two bugs here.
First, the grid should detect Nullable(DateTime) and automatically use a dropdown calendar in the cell.
Second, the UltraCalendarCombo should be able to handle Nullable(DateTime) values.
Are you using the latest hot fix? If not, you should try it and see if these issues are already fixed. If that does not help, you should Submit an incident to Infragistics Developer Support