save image/picture format in Database

Question

0.00/5 (No votes)

See more:

Hi,
I need to save image but i got error.How to solved this error?

C#

byte[] pic = new byte[1];
                pic[0] = 0;
                if (pcbPhoto.Image != null)
                {
                    stream = new MemoryStream();
                    pcbPhoto.Image.Save(stream, System.Drawing.Imaging.ImageFormat.Jpeg);// error occur here...
                    pic = stream.ToArray();
                }

error : A generic error occurred in GDI+.

Regards,
Karthikeyan,
Bangalore.

Posted 26-Sep-12 21:44pm

pkarthionline

Updated 26-Sep-12 21:50pm

Kenneth Haugland

v3

Add a Solution

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

OriginalGriff · Answer 1 · 2012-09-26T21:58:00

Normally, this error occurs because the output stream is in use when you try to save, but since you are outputting to a MemoryStream that is not the case.

Sorry, but the problem is not in teh code you show - it's a lot further back...

The problem is probably that the stream you used to create the image in the first place is no longer available - it has been closed or disposed by the time you get to the Save method. And that doesn't work!
Try this:
When you load the image in the first place, create a new image as a copy of the actual picture, and use that - you can dispose of the original version you read in. For example:

C#

Image myImage;
using (Image inputImage = Image.FromFile(@"D:\Temp\MyPic.jpg"))
    {
    myImage = new Bitmap(inputImage);
    }

Because the new image is not associated with a file or stream, it can be saved with no problem.

Ahmed Mandur · Answer 2 · 2012-09-26T23:04:00

Hi,
Use this code to read picture as Bytes array

C#

MemoryStream stream=new MemoryStream();

            pictureBox1.Image.Save(stream,System.Drawing.Imaging.ImageFormat.Jpeg);
            
            byte[] pic=stream.ToArray();

then insert pic into the database

C#

     SqlConnection con = new SqlConnection
                            ("Data Source=localhost;Initial Catalog=Northwind;Persist Security Info=True;User ID=sa;Password=123456");

         SqlCommand com = new SqlCommand("insert into Employees(LastName,FirstName,Photo) values('aaaa','bbb',@Photo)", con);

com.Parameters.AddWithValue("@Photo", pic);

Hope this helps you,
A.Mandour

save image/picture format in Database

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0