[2008 Exp] DataGridView - NoNullAllowedException

[Bruce Fox]

Hi All,

I have a DGV that is bound to a Table (SQL CE).
The 'Date' field dosn't allow Nulls.

My problem is I get an unhandled error when I press the add new row ('+') in the BindingNavigator twice.
(can also occur when using the down arrow and not having valid data in the preceeding cell)
Obviously this condition is justified - I understand that; I just can figure out a way to either
validate the Date cell on cell exit for example, or catch the error in the BindingNavigators button event.
(This condition can be replicated using the shipped NorthWind DB - as the ID cannot be Null)

I have also coded up the DataSet's 'Partial Class' to no avail.

It seems the error is tied up in the 'System.Data.DataColumn' and I can't get into that.



Ideas?