I have an Oracle database, which I access through a typed dataset.
I have some bound fields and a BindingNavigator on a form (created with the drag/drop functions in VS2005).
When I run the project and click the 'Add New' button on the navigator, it adds one to the internal list and allows editing.
If I click the 'Add New' button again, it throws an exception at the Application.Run(Form1) level, saying one of my columns cannot be null.
I have Googled the problem and come up with other examples: http://groups.google.com/group/microsoft.public.dotnet.framework.windowsforms.databinding/browse_thread/thread/83602e5caf7cc4a8/ff35910ef8f7a755?lnk=st&q=%2B%22BindingNavigator%22+%2B%22add+button%22&rnum=1#ff35910ef8f7a755
I have also tried to add ErrorProvider handling but find that the suggested event is not fired:
I think it has to do with the EndEdit() method of the BindingSource, but I can find no resolution.
How can I trap this error efficiently?