Solved

Get Documents From Image Data Type in SQL Server

Posted on 2006-11-27
3
466 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

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Suggested Solutions

Article by: Ivo
C# And Nullable Types Since 2.0 C# has Nullable(T) Generic Structure. The idea behind is to allow value type objects to have null values just like reference types have. This concerns scenarios where not all data sources have values (like a databa…
Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

744 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now