Retrieving word docs stored in sql server?

[Guest]

Can some help me out retrieving word, pdf, etc. docs and streaming to the
browser?

I'm saving the docs as an image data type along with it's original filename
and retrieving them using a datareader but I'm not sure how to set the
headers properly (i.e Content-Length)

Articles on this using C# would be a big help. Thanks.

 

[Guest]

Hi Dave,

Please look at following Url to read BLOB data from DB:

http://msdn.microsoft.com/library/d...html/cpconobtainingblobvaluesfromdatabase.asp


Then write data:

Response.ContentType = "octet/stream";
EnableViewState = false;
Response.Charset = "";
Response.AddHeader("Content-Disposition", "attachment;filename=wordfile.doc");
Response.BinaryWrite(outbyte);
Response.End();

HTH

Elton Wang