i have problem with inserting image to database sql server

Question

1.00/5 (1 vote)

See more:

hi friends.

i have a problem with inserting image in database. my database column type is image and when i want to enter image in database some data restore in database but it is only 13 bytes whereas my images length is 35155 bytes. in my insert command line i placed a break point and i can see that what is i want to save,it's length is correct(35155 bytes) but when i go to (SSMS) i see that only 13 bytes stored in there. or when i want to retrieve data from database i see that what retrieved from database is only 13 bytes. what is wrong?

thank you.

Posted 8-Jan-15 9:20am

_Starbug_

Add a Solution

Comments

Richard Deeming 8-Jan-15 16:05pm

We can't read your screen, your hard-drive, or your mind. :)

Use the "Improve question" link to update your question with the code you're using to save the image to the database.

2 solutions

Solution 2

You need to use a parameterised statement. There are several articles and tips here on CP that cover it.

Here's one: Load/Unload images into/from DB table[^]

Posted 8-Jan-15 9:33am

PIEBALDconsult

Updated 8-Jan-15 9:35am

v2

Comments

_Starbug_ 8-Jan-15 15:39pm

how can i do this sir.

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)

CPallini · Accepted Answer · 2015-01-08T09:28:00

Solution 1

I would Google for that[^].

Posted 8-Jan-15 9:28am

CPallini

Comments

_Starbug_ 8-Jan-15 15:39pm

i can store data but it is only 13 bytes.

_Starbug_ 8-Jan-15 15:40pm

i am using this. do you think this is incorrect way?

System.Drawing.Image imag = System.Drawing.Image.FromStream(FileUpload1.PostedFile.InputStream);
byte[] Image = null;
Image = new byte[FileUpload1.PostedFile.ContentLength];
HttpPostedFile UploadedImage = FileUpload1.PostedFile;
UploadedImage.InputStream.Read(Image, 0, (int)FileUpload1.PostedFile.ContentLength);

_Starbug_ 8-Jan-15 15:41pm

after this codes i try to store imag in database. but it is only 13 bytes.