Unable to retrieve image from database to picturebox

Question

I have a PictureBox control in my Windows Form.
Datatype of Picture column is 'image' in table 'TableName'
These here is the code which says, take the image from database and put it in PictureBox control:

string connectionString = @"Initial Catalog=DataBaseName;Data Source=DataSourceName;Integrated Security=SSPI;";
            SqlConnection connection = new SqlConnection(connectionString);
            connection.Open();
            SqlDataAdapter da = new SqlDataAdapter(new SqlCommand("Select Picture From TableName where ID = 2 ", connection));
            DataSet ds = new DataSet();
            da.Fill(ds);
            byte[] myImage = new byte[0];
            myImage = (byte[])ds.Tables[0].Rows[0]["Picture"];
            MemoryStream stream = new MemoryStream(myImage);
            pictureBox1.Image = Image.FromStream(stream);
            connection.Close();

Usually it always works but now its showing a ArgumentExeption with error 'Paramerter is not valid' at this line pictureBox1.Image = Image.FromStream(stream);
I don't understand? Which Parameter?

Any help will be appreciated.

do you have checked that the db query is returning a valid result? — Mate
– Mate, Commented Nov 30, 2012 at 6:44
Yes, it is showing valid results. My only problem is PictureBox is not taking image from the MemoryStreams object. — shanu
– shanu, Commented Nov 30, 2012 at 6:48

Community · Accepted Answer · 2020-06-20 09:12:55Z

1

It seems to lay on the way you save and read the object from the database, the exception is comming from Image.FromStream(stream); MEthode, MSDN say about this exception:

The stream does not have a valid image format -or- stream is null.

So as you mentioned its not Null in your question i assume youre saving the data or reading it in a uncompatible way.

edited Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered Nov 30, 2012 at 6:55

CloudyMarble

37.7k70 gold badges103 silver badges133 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Mate Over a year ago

Could you try to save a file stream to disk and check if the content is valid... Example here : stackoverflow.com/questions/3879650/….

Mate Over a year ago

When you try to save to file? In this case the problem is the data stored into db... and the solution is not in this piece of code. You need to review the way in which it is stored

shanu Over a year ago

@Mate Yes you are right i have checked it on database and it is saving the same byte array in the Picture column for every other image

Mate Over a year ago

Great! Now to check that! As a last comment ... I recommend you do not use a dataset if it is extremely necessary to get a picture. Here an example with a SqlDataReader: codeproject.com/Questions/145368/…

shanu Over a year ago

@MeNoMore I am using the usual way to store the images in database ` MemoryStream stream = new MemoryStream(); pictureBox1.Image.Save(stream, ImageFormat.Jpeg); byte[] uploadImage = stream.ToArray();`

Collectives™ on Stack Overflow

Unable to retrieve image from database to picturebox

1 Answer 1

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related