Hi All,
I have a bound TrueDBGrid(V2.0.20072.61122) that displays a number of datetime values from a stored procedure which I would like to edit.
The stored procedure returns datetime values that are converted from integer values that store the number of seconds from midnight.
The problem I have is that when I bind the datetime values the grid will not allow me to edit the columns (does not fire the event), if I change the stored procedure to bring through the integer values it allows the edit with a time picker user control I have written and bound to the .Editor method
Here is the code
flexShiftPattern_Details.DataSource = m_Dataset_Shifts_Details.Tables(0)
flexShiftPattern_Details.Splits(0).DisplayColumns(0).Visible =
FalseFor i As Int32 = 1 To flexShiftPattern_Details.Splits(0).DisplayColumns.Count - 1
flexShiftPattern_Details.Columns(i).NumberFormat =
"FormatText Event"
flexShiftPattern_Details.Columns(i).EnableDateTimeEditor =
False
flexShiftPattern_Details.Columns(i).Editor = m_TimePicker
flexShiftPattern_Details.Splits(0).DisplayColumns(i).AutoSize()
Next
Any help you can provide would be appreciated.
Phil