How to validate a DataGridViewComboBoxCell??

Question

I have problem with validating combo box cells. I can't figure it out how to do it. CellValidating event gives me only the formatted value of the cell. Thtat's useless for combo boxes. I need to validate the value not the displayed text. The value object of the combo box cell is null during the (first) Validation event. It gets updated after the validation. So how to validate the actual value of a combo box cell?

Thanks!

Bechir Bejaoui · Answer

I see what if you try this to implement the onleave or the onmouseleave event handler http://msdn.microsoft.com/en-us/library/system.windows.forms.datagridviewcell.onleave.aspx http://msdn.microsoft.com/en-us/library/system.windows.forms.datagridviewcell.onmouseleave.aspx To impose your format and you can use the Reqular expression for that System.Text.RegularExpressions

Ivar · Answer

I can validate all cells ok. The problem was with combo box cell value. I had set combo box column's value member and display member. Value member is an ID of a record and display member is it's name. I needed to validate the ID of combo box cell. Validating event gives me only the new formatted value(display member) and data grid view's current cell value contains the old value of the cell during the validating event. Now I have found solution for that. I can cast the data grid view's editing control to combo box and get the new value from there.

Bechir Bejaoui · Answer

You can implement the data grid view cell validating or cell validated event handler But verify that CauseValidation property is set to true