Hi,
i like the user to add a Datei and - optionally - a time into a cell.
So i set the Input-Mask like: this.dfgrid1.DisplayLayout.Bands[0].Columns["Datum"].MaskInput = "{date} {time}";
This works in a way, that the user can type along the date and the time.
BUT: If user only enters the date-part and leaves the time-part empty, an error occurs. Fair enough, but not what i like to happen :)
I would like to set the Time-Part to 00:00 if it isn't entered by the user. How could i do that? (I'm sure it's pretty simple but i'm looking at the wrong properties/events)
The below code worked for me:
With ugmain.DisplayLayout.Bands(0).Columns(M_FIELDNAME_ACTUAL_END_TMS) .Header.Appearance.TextHAlign = HAlign.Center .CellActivation = UltraWinGrid.Activation.AllowEdit .Style = UltraWinGrid.ColumnStyle.DateTimeWithoutDropDown .MaskInput = "mm/dd/yy hh:mm" .NullText = "00/00/00 00:00"
If .Editor IsNot Nothing AndAlso TypeOf .Editor Is Infragistics.Win.DateTimeEditor Then
'This allows to skip the time part if not needed. DirectCast(.Editor, Infragistics.Win.DateTimeEditor).AutoFillTime = UltraWinMaskedEdit.AutoFillTime.Midnight End If End With
dfboris said:I think my next approach will be to use an UserControl as Cell-Editor, an Usercontrol that has two controls for Date and Time... i'll give it a try
That sounds like an excellent approach. You can use UltraControlContainerEditor to embed your UserControl in the cell.
Oh, OK - To know, that there is not an easy way out helps a lot :) I thought i missed something. I think my next approach will be to use an UserControl as Cell-Editor, an Usercontrol that has two controls for Date and Time... i'll give it a try
This is actually not very easy to do in a reliable way.
One very simple way to do it would be like this:
private void ultraGrid1_BeforeExitEditMode(object sender, Infragistics.Win.UltraWinGrid.BeforeExitEditModeEventArgs e) { var grid = (UltraGrid)sender; UltraGridCell activeCell = grid.ActiveCell; if (activeCell.Column.Key == "DateTime 1") { string cellText = activeCell.Text; if (cellText.EndsWith("__:__ __")) { cellText = cellText.Substring(0, cellText.Length - "__:__ __".Length); DateTime newDateTime; bool success = DateTime.TryParse(cellText, out newDateTime); if (success) activeCell.EditorResolved.Value = newDateTime; } } }
So this code explicitly looks to see if the Time portion of the DateTime is empty and if so, parses a date based solely on the Date portion of the text.
But this code is flawed because it doesn't account for culture. I've hard-coded it to work with the culture on my machine. On my machine, "{date} {time}" returns a date with a 4-digit year and a time format with an colon and an AM/PM symbol. But this might vary on other machine which are set to different cultures. So the right thing to do would be to use the current culture to get the property strings and string lengths. Unfortunately, this is not simple and the DateTime editor doesn't use the system settings directly when you use "{time}" - it modifies the format slightly to provide 2 digits for the hour in the mask.
So the code I have here will work in a simple case as long as the culture is the same on all machines running you application. Otherwise, I don't see any way to achieve what you want.