error in picture box when display image from database

Question

0.00/5 (No votes)

See more:

i use below coading for set image from database, its give error please help..!!

C#

byte[] imageSource = ((byte[])dtCompany.Rows[0]["CompanyLogo"]);
                            MessageBox.Show(Convert.ToString(imageSource));
                            Bitmap image;
                            using (MemoryStream stream = new MemoryStream(imageSource))
                            {
                               image = new Bitmap(stream);
                            }
                            pbCompanyLogo.Image = image;

Posted 25-Sep-12 23:09pm

Member 9444634

Updated 25-Sep-12 23:25pm

Kenneth Haugland

v2

Add a Solution

Comments

vaibhav mahajan 26-Sep-12 5:53am

dont use ie6...

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)

Ahmed Mandur · Answer 1 · 2012-09-25T23:20:00

Hey,
I wish that this is the solution that you are looking for

use this code to Insert A pic into DB

C#

//We are using SQL express.
            //My database name is "PictureDb".
            SqlConnection con = new SqlConnection
                               ("Server=.;database=PictureDb;integrated security=true");
            //I have used a table named "tblUsers" and fill the fields
            SqlCommand com = new SqlCommand("insert into tblUsers
                            (fldCode,fldPic) values(1,@Pic)", con);

            //In here, I have to save the picturebox image to tblUsers
            //because you were not able to send the PictureBox1.Image
            //to field "fldPic" that is of kind
            //"image" in SQL SERVER EXPRESS, then you should do something else
            // and that is converting
            //your picture box image to an array of bytes and then sending
            //that array to database.
            //Below, we have used a stream which will be used to
            //contain our picturebox image bytes.
            MemoryStream stream=new MemoryStream();
            //through the instruction below, we save the
            //image to byte in the object "stream".
            pictureBox1.Image.Save(stream,System.Drawing.Imaging.ImageFormat.Jpeg);

            //Below is the most important part, actually you are
            //transferring the bytes of the array
            //to the pic which is also of kind byte[]
            byte[] pic=stream.ToArray();

            com.Parameters.AddWithValue("@Pic", pic);
            try
            {
                con.Open();
                com.ExecuteNonQuery();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            finally
            {
                con.Close();
            }

And This Code To recieve the picture from DB

C#

SqlConnection connect = new SqlConnection
                             ("Server=.;database=PictureDb;integrated security=true");
            SqlCommand command = new SqlCommand
                                ("select fldPic from tblUsers where fldCode=1", connect);
            //for retrieving the image field in SQL SERVER EXPRESS
            //Database you should first bring
            //that image in DataList or DataTable
            //then add the content to the byte[] array.
            //That's ALL!
            SqlDataAdapter dp = new SqlDataAdapter(command);
            DataSet ds = new DataSet("MyImages");

            byte[] MyData = new byte[0];

            dp.Fill(ds, "MyImages");
            DataRow myRow;
            myRow = ds.Tables["MyImages"].Rows[0];

            MyData = (byte[])myRow["fldPic"];

            MemoryStream stream = new MemoryStream(MyData);
            //With the code below, you are in fact converting the byte array of image
            //to the real image.
            pictureBox2.Image = Image.FromStream(stream);

Regards,
A.Mandour

OriginalGriff · Answer 2 · 2012-09-25T23:16:00

Normally, the problem you get is "Parameter is not valid." which indicates that the data in teh database is not a valid image. Often the problem is actually caused when the image is loaded into the database, particularly if the image is saved by concatenating strings to form an SQL command:

C#

string sql = "INSERT INTO myTable (imageData) VALUES ('" + myImage + "')";

Actually generates an sql string:

SQL

INSERT INTO myTable (imageData) VALUES ('System.Drawing.Bitmap')

Which won't throw an error, but also doesn't store the actual image data.

Check your DB, and if this is the case use parametrized queries to load the DB instead of string concatenation (you should be doing that anyway as a matter of course).

error in picture box when display image from database

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0