The image from the DB displays fine.  I can add/edit the image on the form.  It persists in the DB without errors.

If I choose CUT or DELETE from the context menu, I get a DBNull error popping up.  Of course, this is not expected (is it ever?) since I spent a good chunk of time yesterday wrestling with the null issue and the image.  I thought I had that thing licked.

What can I do about the delete/cut process on the pictureedit control?

Thanks,
Bill

Without changing my database in any way I added this code:

private void SketchPictureEdit_EditValueChanged(object sender, EventArgs e)
{
    if (SketchPictureEdit.EditValue == new byte[] {})
    {
        this.partsBO1.sketch = new byte[] {};
        SketchPictureEdit.EditValue = string.Empty;
    }
    else
    {
        this.partsBO1.sketch = (byte[])SketchPictureEdit.EditValue;
    }
}

This works.  I am still running some tests, but at least I have a way around the issue.

The first thing that the EditValueChanged event needs to check is the editing state of the BO.  If adding or editing, then the code can run; otherwise, it should skip it.  The editing state will be changed by the following line of code:

this.partsBO1.sketch = (byte[])SketchPictureEdit.EditValue;

That is why my navigation disappeared.  And, also explains the confirmation popup when closing the window.

Whew!  Glad that's over.
Bill

(note: cross-posted on purpose--http://forum.strataframe.net/Topic13453-7-1.aspx)

Since this error is happening within the Set, not the Get, it looks like the PictureEdit control is actually passing back a DBNull.Value out of its bound property.  Is there a NullValue property somewhere on the control where you can set what the control considers to be "null" to pass back to the data source?  Some of them allow you to pass back either a DBNull.Value or a "null" (C# keyword) or an empty value.

Nope...no NullValue property that I can discover.  There is a NullText property, but it isn't providing the binding value that I need.

Thanks for the help!
Bill

Oh...btw...I removed the following code (in red):

private void SketchPictureEdit_EditValueChanged(object sender, EventArgs e)
{
    if (SketchPictureEdit.EditValue == new byte[] {})
    {
        this.partsBO1.sketch = new byte[] {};
        SketchPictureEdit.EditValue = string.Empty;
    }
    else
    {
        this.partsBO1.sketch = (byte[])SketchPictureEdit.EditValue;
    }
}

Since I have the control bound to the data already, this was redundant.  And, it caused other navigation problems at various points in the user experience.

Ah...yeah, that could cause an issue   Glad you found it.