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.

Answer 1

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);

Answer 2

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.