database image field passing null value

Question

How to pass null value to database field having type of image. I am trying this but getting an error:

if (photo)
    cmd.Parameters.AddWithValue("EPhotograph",img);
else
    cmd.Parameters.AddWithValue("EPhotograph", "");
if (signn)
    cmd.Parameters.AddWithValue("ESignature",sign);
else
    cmd.Parameters.AddWithValue("ESignature",DBNull.Value);

What is the error you got? Please post it. Or may be the database column ESignature is not a Nullable column. Ensure it is not NOT NULL — Mahmoud Gamal, Commented Jul 10, 2012 at 7:40

Bob Kaufman · Accepted Answer · 2012-07-10 13:48:28Z

2

Instead of DBNull.Value please try to put empty byte array like this new byte[0];

Reason SQL image type requires byte array as value in them.

edited Jul 10, 2012 at 13:48

Bob Kaufman

12.8k16 gold badges82 silver badges111 bronze badges

answered Jul 10, 2012 at 7:52

HatSoft

11.2k3 gold badges30 silver badges43 bronze badges

Add a comment |

Collectives™ on Stack Overflow

database image field passing null value

1 Answer 1

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Related