How to Convert attachments to image data type

Question

0.00/5 (No votes)

See more:

Hi,

I have one requirement in asp.net i.e. From File upload control we have to select any type of attachment(.doc,pdf,.jpeg......) then we have to convert into sql server image data type then we have to save in SQL Server database.

Please help!!!

Thanks,
Codehub.

Posted 26-Dec-13 1:29am

codehub

Updated 27-Dec-13 22:12pm

agent_kruger

v2

Add a Solution

3 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)

OriginalGriff · Answer 1 · 2013-12-26T01:44:00

You can't convert "any type of attachment" to an image - you need an attachment type that you can read and process into an image, which means having an application that can cope with the data format as a minimum. For example, if the client uploads a Word file your server must have Word (or a similar program) that can read the file in order to understand it - and that program must have the facility to produce an image from the document. Not all do.

Most of the time, what the user uploads is irrelevant: just store it in SQL (or in a file and store the path in SQL) and allow him to download it again. Think about it: if he uploads a 2 hour video file, which frame should you use for the image if you generate it?

Gitanjali Singh · Answer 2 · 2013-12-26T01:43:00

Solution 1

http://www.dotnetgallery.com/kb/resource21-How-to-store-and-retrieve-images-from-SQL-server-database-using-aspnet.aspx[^]
This may help

Posted 26-Dec-13 1:43am

Gitanjali Singh

agent_kruger · Answer 3 · 2013-12-27T22:12:00

Solution 3

you cannot change file into image but to save in SQL you could convert the file into string and then save it. See the below link
http://stackoverflow.com/questions/6850850/reading-file-content-to-string[^]

Posted 27-Dec-13 22:12pm