Retrieve Image from database

Question

1.00/5 (1 vote)

See more:

C#

image

I inserted a transparent image (.png) in my database but when retrieving the image, the background became black,. Why?

Posted 16-Jun-11 17:26pm

tedhanna

Add a Solution

Comments

Sergey Alexandrovich Kryukov 16-Jun-11 23:39pm

It cannot be so. Details, please. Did you really compare binary files? How do you know what happened, exactly?
--SA

tedhanna 17-Jun-11 0:00am

here is my code
saving the image:
Bitmap pictype = new Bitmap(pbSignature.Image);
MemoryStream _Stream = new MemoryStream();
pictype.Save(_Stream, ImageFormat.Jpeg);
blUser.Signature = _Stream.GetBuffer();

retrieving the image:
MemoryStream _Stream = new MemoryStream(blUserDetails.Signature);
pbSignature.Image = Image.FromStream(_Stream);

The data type of my column in database is Image.
when uploading the image to the picturebox it is just fine but when retrieving the image background become black.

tedhanna 17-Jun-11 0:05am

I resolved it by myself i just changed the pictype.Save(_Stream, ImageFormat.Jpeg); to pictype.Save(_Stream, ImageFormat.Png);

since the Jpeg format won't allow transparent image that's why the background becomes black.

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)

tedhanna · Accepted Answer · 2011-06-16T18:07:00

Solution 2

I resolved it by myself i just changed the

pictype.Save(_Stream, ImageFormat.Jpeg);
to
pictype.Save(_Stream, ImageFormat.Png);

since the Jpeg format won't allow transparent background of an image that's why the background becomes black.

Posted 16-Jun-11 18:07pm

tedhanna