Solved

Get Documents From Image Data Type in SQL Server

Posted on 2006-11-27
3
470 Views
Last Modified: 2012-06-27
Hi,

If I have documents such as word, pdf, etc.. stored in my SQL Server DB as an "image" datatype, what's the best way to write a program in C# to retrieve these documents.  Please advise.

Thanks,
0
Comment
Question by:tinman1412
3 Comments
 
LVL 5

Accepted Solution

by:
rameedev earned 50 total points
ID: 18025481
check this url http://support.microsoft.com/default.aspx?scid=kb;EN-US;309158

this is for the BLOB datatype but should work the same for Image datataype..bcoz finally when you retrive a BLOB or image data from sql server it is usaully stored in a byte array which can be written using a file stream.
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Summary: Persistence is the capability of an application to store the state of objects and recover it when necessary. This article compares the two common types of serialization in aspects of data access, readability, and runtime cost. A ready-to…
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

805 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question