How to insert and read a pdf file to Sql Server 2005 database using C#

Question

Hello,

can anyone say how to insert the pdf file into sqlserver 2005 and read the pdf file from sqlserver...

Thanks in advace

Answer 1

If you are interested into using database for file storage, look at this 4guysfromrolla article. It's web oriented, but there should be no problem finding what you need.

Answer 2

Essentially, you are just talking about BLOB storage and retrieval (of image or varbinary(max) data). See this question: Streaming directly to a database