how to set image type column to null in sql server using parameters in c#

Question

I tried to set the parameter value to system.dbnull.value but got some errors. thanks.

Show us the code where you set the parameters, and the sql, please. — Chris
– Chris, Commented Jun 15, 2009 at 23:04

Matthew Jones · Accepted Answer · 2009-06-15 21:34:54Z

2

What is happening is that SQLServer is reading the NULL type as nvarchar, which cannot be used to update an Image column.

Try specifying the Parameter Type as SqlDbType.Image

SqlParameter myParam = new SqlParameter("@NameOfParameter",SqlDbType.Image);

edited Jun 15, 2009 at 21:34

answered Jun 15, 2009 at 21:29

Matthew Jones

26.3k17 gold badges105 silver badges156 bronze badges

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

Comments

Andrew · Accepted Answer · 2009-07-07 08:05:16Z

0

An alternative is to not use a parameter when you're setting it to null. Instead, you can hardcode '=null' in the SQL command and skip parameters completely.

answered Jul 7, 2009 at 8:05

Andrew

12k12 gold badges72 silver badges86 bronze badges

1 Comment

cjk Over a year ago

This works, but he might be coding this into his datalayer and wants to be able t o set the correct parameter value.

Collectives™ on Stack Overflow

how to set image type column to null in sql server using parameters in c#

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