How to insert null value in ms access of image value from C# windows form?

Question

0.00/5 (No votes)

See more:

i want to make that user select image then insert that image in ms access and if not select then insert null value or something else that i don't know.

What I have tried:

i do this:

if(pb_new.image.toString() == "")
{
   param[0] = new oledbparameter("@Image",oledbtype.varbinary);
   param.value = "" or string.empty() 
}
else
{
   param[0] = new oledbparameter("@Image",oledbtype.varbinary);
   param[0].value = image;
}

there is picturebox which i give name pb_new and there is image which store image memory allocation and other things.

Posted 19-Sep-16 4:15am

Member 11572517

Updated 19-Sep-16 4:28am

Wendelius

v3

Add a Solution

Comments

[no name] 19-Sep-16 10:20am

An empty string is not the same as null. And, your code won't compile anyway.

Member 11572517 19-Sep-16 10:21am

yes, u r right sir, there is error, object reference and ........

what can i do sir for do this.. thank u in advance

[no name] 19-Sep-16 10:30am

You could try asking questions with all the information necessary to answer the question. And you could also try losing the txtspeak. "u" is a letter of the alphabet, it is not a word used in sentences. "r" is not a work either.

Member 11572517 19-Sep-16 10:35am

sir, same error, object reference not set to an instance........

1 solution

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)

Wendelius · Answer 1 · 2016-09-19T04:28:00

Solution 1

If I understand your question correctly, you should use DBNull.Value Field (System)[^]

For example

C#

param[0].Value = System.DBNull.Value

Posted 19-Sep-16 4:28am

Wendelius

Comments

Member 11572517 19-Sep-16 10:30am

ok, sir i try.