how can i insert an image into database and select it again

Question

0.00/5 (No votes)

See more:

i want to insert an image and select it again from database into picturebox i have succeeded to insert it into database (image column) but when i select it again i get an error "The Parameter Is Not Valid" i think the insert statement has something incorrect,any sample of code for inserting an image into database and select it again?

Thanks.

Posted 4-Aug-11 10:29am

snake1

Add a Solution

Comments

Wonde Tadesse 4-Aug-11 17:06pm

Tag your question properly. WinForms, WPF ...

Christian Graus 4-Aug-11 17:25pm

The internet abounds with sample code that does this. Online articles will contain more detail than a forum reply, every time.

Wonde Tadesse 4-Aug-11 19:31pm

Well, Can you post your code how you did it ?

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)

thatraja · Answer 1 · 2011-08-04T17:26:00

Solution 2

Check these answers

Storing Image in Sqlserver table[^]
How to save and retrieve Image in Database using Asp.net[^]

Posted 4-Aug-11 17:26pm

thatraja

divesh12 · Answer 2 · 2011-08-04T11:33:00

Solution 1

Change your image in byte and then Insert in DataBase and Retrieve time retrieve that byte again and convert it again.

Posted 4-Aug-11 11:33am

divesh12

Comments

snake1 4-Aug-11 19:20pm

i have already done this but there's an exception "The Parameter Is Not Valid" maybe i'm doing something wrong can you explain with some code please ?

divesh12 5-Aug-11 8:53am

Please Post your code here.

snake1 20-Aug-11 3:18am

Insert Step
//---------------
MemoryStream ms = new MemoryStream();
PBoxGuestImage.Image.Save(ms, ImageFormat.Jpeg);
Byte[] PicArray = new Byte[ms.Length];
ms.Position = 0;
ms.Read(PicArray, 0, PicArray.Length);

CMD.CommandText = "Insert Into TestTable(TestImage) Values (@ParTestImage)"
CMD.Parameters.AddWithValue("@ParTestImage", PicArray);
//---------------
this works great

Retrieve Step

Image NewImage;
byte[] content = (byte[])TestReader["TestImage"];
TestPictureBox.Image = null;
using (MemoryStream stream = new MemoryStream(content, 0, content.Length))
{
stream.Write(content, 0, content.Length);
NewImage = Image.FromStream(stream, true); //at this line i get the exception
}
TestPictureBox.Image = NewImage;