passing null to DBtype.binary

Question

I am using sqlparameter to insert value in to the table through procedure i have a prameter in procedure of type image in c# i set the parameter type as DbType.Binary now i want to pass Null value to the parameter if i use DBNull.value, i get incompatible data type error

What happens if you set it to a CLR null?

grenade
– grenade

2009-08-21 08:46:35 +00:00
Commented Aug 21, 2009 at 8:46 — grenade
– grenade, Commented Aug 21, 2009 at 8:46

IordanTanev · Accepted Answer · 2011-11-17 13:54:53Z

2

Try like this int the sp set parametar default value null like this @parametar Binary = NULL and then in the code test if the value is null and if it is null just don't pass parameter to the sp and it will take default value null.

edited Nov 17, 2011 at 13:54

user142162

answered Aug 21, 2009 at 8:45

IordanTanev

6,2905 gold badges42 silver badges49 bronze badges

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

Collectives™ on Stack Overflow

passing null to DBtype.binary

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related