how to insert null value to varBinary(Max) Database Column

Question

0.00/5 (No votes)

See more:

hi all,

I have FileUpLoad control and Image control. i want to insert Null value when image is not there to respective column.I've used following code,

cmd.Parameters.AddWithValue("@staff_photo", DBNull.Value);
cmd.Parameters.AddWithValue("@staff_photo", string.empty);

And these code are not working.So please reply with example

Posted 24-Apr-11 21:10pm

ks ravi

Add a Solution

Comments

Ankit Rajput 25-Apr-11 3:11am

Is there any exception with this code?

ks ravi 25-Apr-11 3:26am

nvarchar is incompatible with varBinary(max)

Prerak Patel 25-Apr-11 3:21am

DBNull should work. What is the exact error? Is staff_photo not nullable by any chance?

ks ravi 25-Apr-11 3:28am

nvarchar is incompatible with varBinary(max)

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Prasanta_Prince · Answer 1 · 2011-04-24T21:17:00

Solution 1

Just Allow null in Database Schema and thats all. After that if you dont provide any value it will autometically treat as a null value.

Posted 24-Apr-11 21:17pm

Prasanta_Prince

Comments

ks ravi 25-Apr-11 3:30am

den how to pass Null value or Image through Stored Proc Parameter(@staff_photo)

Prerak Patel · Answer 2 · 2011-04-24T21:32:00

Solution 3

nvarchar is incompatible with varBinary(max)

Then try this,

cmd.Parameters.Add("@staff_photo", System.Data.SqlDbType.VarBinary).Value = DBNull.Value;

And as I said in comment, it must be nullable.

Posted 24-Apr-11 21:32pm

Prerak Patel

Updated 24-Apr-11 21:33pm

v2

Comments

Ponka Nemov 22-Mar-12 15:45pm

this last solution proposed by Perak works.

ravi prach · Answer 3 · 2012-05-22T00:19:00

Solution 4

define in store procedure
@staff_photo varchar(50)=null, if you are saving only photo path

Posted 22-May-12 0:19am

ravi prach