I have noticed that the combined date time editor is a bit tricky to use and prone to end user frustration. Is there a way I can split a date_time field in a databse into 2 columns in the grid? One for date and one for time?
Peter
I think you don't need to actually split it. Just take the column out of database twice like
SELECT dateDOB AS date1, dateDOB AS date2 FROM tableUser
and then set the Format property of each column to ask each column to display either the date or the time.
Doesn't the update on that get a bit weird? If I change the date column and the time column, I have to write a method that keeps the two in sync.
Yes, you would need to handle this yourself and re-combine the values. You could just do this in the grid rather than the data source by hiding the "real" DateTime column and adding a couple of unbound columns (one for date and one for time). But there's nothing built-in to the grid to do this for you, you would have to doce the splitting (probably in InitializeRow) and combining (probably in BeforeRowUpdate), yourself.