Hey all-

I have a DataGridView in which I wanted to host a DateTimePicker, so I used the example from:

http://msdn2.microsoft.com/en-us/library/7tas5c80.aspx

Has anyone gotten this example working properly for keyboard input? It works great when you use the mouse, but under certain circumstances the value from the editing control doesn't get back into the datagridview.

To reproduce:

1. Enter the date cell with the mouse
2. Type a new month with thenumeric keys only
3. Hit Tab or enter toleave the cell.

Now, the above works fine if you leave the editing control with the mouse, or if you use theup/down arrow keys to change the month value.

I did some debugging in the editing control, and it appears that if the follow the steps about the EditingControlFormattedValue property is not being called after the OnValueChanged function fires. Normally that property is being retrieved prior to the EndEdit event on the datagridview.

Does anyone have any ideas on what to check?

Thanks,

Korey

Ok, if anyone else finds themselves in the same situation, I found a fix. Add the CellLeave event handler to your datagridview and use the following code:

void dgv_CellLeave(object sender, DataGridViewCellEventArgs e)

{

if (dgv.EditingControl is CalendarEditingControl)

{

dgv.EditingPanel.Select(); // force validation on editing control

}

}

I did some more research on this issue, and while I don't have a solution I'm got some more information:

Here's what happens when you tab into a calendar cell, hit f2 to edit, hit the up arrow key, then hit tab to leave the cell:

1. dgv::CellBeginEdit
2. CalendarEditingControl::OnValueChanged:10/11/2006 12:00:00 AM
3. CalendarEditingControl::InitializeEditingControl:10/11/2006 12:00:00 AM
4. dgv::EditingControlShowing
5. CalendarEditingControl::GetEditingControlFormattedValue:10/11/2006
6. CalendarEditingControl::EditingControlWantsInputKey: up arrow
7. CalendarEditingControl::OnValueChanged:11/11/2006 12:00:00 AM
8. CalendarEditingControl::GetEditingControlFormattedValue:11/11/2006
9. dgv::CellValidating
10. CalendarEditingControl::GetEditingControlFormattedValue:11/11/2006
11. dgv::CellValidated
12. dgv::CellEndEdit

Now here's what happens when you tab into a calendar cell, hit f2 to edit, type a number, then hit tab to leave the cell:

1. dgv::CellBeginEdit
2. CalendarEditingControl::OnValueChanged:10/11/2006 12:00:00 AM
3. CalendarEditingControl::InitializeEditingControl:10/11/2006 12:00:00 AM
4. dgv::EditingControlShowing
5. CalendarEditingControl::GetEditingControlFormattedValue:10/11/2006
6. CalendarEditingControl::EditingControlWantsInputKey: numeric 7
7. CalendarEditingControl::GetEditingControlFormattedValue:10/11/2006
8. dgv::CellValidating
9. dgv::CellValidated
10. CalendarEditingControl::OnValueChanged:7/11/2006 12:00:00 AM
11. dgv::CellEndEdit

Notice that the OnValueChanged handler with the new date (7/11/2006) doesn't get called until after the cell validation, etc. on the datagridview... If I understand correctly, the datagridview's cell is being flagged as dirty in that OnValueChanged function on the CalendarEditingControl. The editing control is never being asked for its new value (through GetEditingControlFormattedValue).

By the way, I also added the numeric keys to the WantsInputKey override on the CalendarEditingControl, but that didn't change anything.

Anyone have any ideas?

Thanks,

Korey

In the CalendarEditiingControl class there is a function EditingControlWantsInputKey. It is only allowing the left, up, down, right, home, end, pageup, and pagedown keys to go to the DateTimePicker. You can add to the list of the accepted keys.

Class CalendarEditingControl Inherits DateTimePicker Implements IDataGridViewEditingControl etc........... Public Function EditingControlWantsInputKey(ByVal key As Keys, _ ByVal dataGridViewWantsInputKey As Boolean) As Boolean _ Implements IDataGridViewEditingControl.EditingControlWantsInputKey ' Let the DateTimePicker handle the keys listed. Select Case key And Keys.KeyCode Case Keys.Left, Keys.Up, Keys.Down, Keys.Right, _ Keys.Home, Keys.End, Keys.PageDown, Keys.PageUp Return True Case Else Return False End Select End Function

Thanks for the reply, Ken. However, I've already tried that. Ireturned true forD0, D1, D2, etc. I traced the execution,and WantsInputKey gets called and does in fact return true when I type a numeric key. It didn't change the order of execution I listed above, unfortunately... It really seems like that should be the right answer.

Thanks,

Korey

Ok, if anyone else finds themselves in the same situation, I found a fix. Add the CellLeave event handler to your datagridview and use the following code:

void dgv_CellLeave(object sender, DataGridViewCellEventArgs e)

{

if (dgv.EditingControl is CalendarEditingControl)

{

dgv.EditingPanel.Select(); // force validation on editing control

}

}

This workaround creates a new problem:

If you try to click away from the DataGridView while this Editing Control is showing, the program will freeze for a reason I have yet been unable to determine.

I've just encountered this problem too. Have you found a workaround that doesn't cause any other problems?

Also I have another question. How do you enable the user to blank out a value once a date has been selected? Ideally I would like them to be able to select the entire date and hit Backspace or Delete like a normal text field.

Here are answers to both of your questions:

My workaround was to place the following code into the DGV [CellValidating] event (not the CellLeave event):

In order to clear the value, you should handle the DGV [KeyDown] event for individual columns, like so:

Hope that helps you.

Andre

Thanks Andre. The workaround worked a treat.

Has anyone tried using the Calendar Column with a nullable DateTimePicker ? I can't get it to work ...

Thanks.