How to pull image out of database?

Question

0.00/5 (No votes)

See more:

I have a database table in SQL 2005 with a column of images (image datatype). The images are GIFs. I can write a VBScript and write out the images using ADO and I can open them just fine. When I use ADO.Net, the file doubles in size and will not open. If I insert into the table using ADO.net, I can pull it out just fine. The data is/was put in using ADO.

How can I pull the images out of the table using ADO.Net and construct them back as GIFs? Is there some translation somewhere that I am missing?

Posted 6-Jul-10 6:19am

William Mitchell

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)

Abhishek Sur · Answer 1 · 2010-07-06T11:24:00

See in SQL Server 2005, image datatype is similar to Byte Arrays.

So just retrieve the data from the database as a Byte array and write to the file wheneever required. To understand the mimetype of the image, you need to store the mime type separately.

I hope this will help you.

Storing and Retrieving Images from SQL Server using Microsoft .NET[^]

:):rose:

William Mitchell · Answer 2 · 2010-07-07T01:48:00

Solution 2

I am pulling it out as a byte array and writing it to a file. Unfortunately when I do that with .Net, it is twice the size of the same image written out using ADO & VBScript. Also, the image written using ADO.Net is not at all an image. The ADO image will render correctly.

Posted 7-Jul-10 1:48am