How to insert NULL value in image column using C# code

Question

I have the following code

cmd. Parameters. AddWithValue("@Password",
    (string.IsNullOrEmpty(member.Password))
        ? (object)DBNull.Value
        : member.Password);
cmd.Parameters.AddWithValue("@Image",
    (member.Image==null)
        ? (object)SqlDbType.Image
        : member.Image);

unable to add null value to image column.

I get this error:

Operand type clash: int is incompatible with image

yes I have tried but it ask @image parameter value is not supplied — Fahad Altaf
– Fahad Altaf, Commented Feb 17, 2014 at 12:19
cmd.Parameters.AddWithValue("@Image", (member.Image==null) ? (object)DBNull.Value : member.Image); — Fahad Altaf
– Fahad Altaf, Commented Feb 17, 2014 at 12:29

Marc Gravell · Accepted Answer · 2014-02-17 12:19:36Z

7

Here you go: you're passing SqlDbType.Image (more commonly known as 7) when you should be passing a null:

cmd.Parameters.AddWithValue("@Image",
(member.Image==null)
    ? (object)DBNull.Value
    : member.Image);

If you want to specify the data type explicitly, do that separately; for example:

cmd.Parameters.AddWithValue("@Image",
(member.Image==null)
    ? (object)DBNull.Value
    : member.Image).SqlDbType = SqlDbType.Image;

answered Feb 17, 2014 at 12:19

Marc Gravell

1.1m273 gold badges2.6k silver badges3k bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Stephen Rauch · Accepted Answer · 2018-05-13 03:26:23Z

0

this is only solution your problem

int filLength = 0;
byte[] byteImageArray;
byteImageArray = new byte[Convert.ToInt32(filLength)];
cmd.Parameters.AddWithValue("@Image",
    (member.Image==null)
        ? byteImageArray
        : member.Image);

edited May 13, 2018 at 3:26

Stephen Rauch♦

50.1k32 gold badges118 silver badges143 bronze badges

answered May 13, 2018 at 3:07

Shayannasab

1

1 Comment

FanaticD Over a year ago

Hello and welcome to Stack Overflow! Would you please elaborate and comment a little bit more on why this solution works?

Collectives™ on Stack Overflow

How to insert NULL value in image column using C# code

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related