PDF Files stored in SQL Server!?!?!

Okay, I found the solution.

To download:

Response.ContentType = dsPDF.Tables[0].Rows[0]["strPDFFileWordMime"].ToString();

Response.OutputStream.Write((byte[])dsPDF.Tables[0].Rows[0]["imgPDFFileWordDoc"],0,Convert.ToInt32(dsPDF.Tables[0].Rows[0]["intPDFFileWordLength"]));

Response.AddHeader("Content-Disposition","attachment;filename=" + dsPDF.Tables[0].Rows[0]["strPDFFileWordName"].ToString());

Response.Flush();

Response.End();

and to Display:

Response.ContentType = dsPDF.Tables[0].Rows[0]["strPDFFileWordMime"].ToString();

Response.OutputStream.Write((byte[])dsPDF.Tables[0].Rows[0]["imgPDFFileWordDoc"],0,Convert.ToInt32(dsPDF.Tables[0].Rows[0]["intPDFFileWordLength"]));

Response.AddHeader("Content-Disposition", "inline;filename=" + dsPDF.Tables[0].Rows[0]["strPDFFileWordName"].ToString());

Response.Flush();

Response.End();

it's the word inline in the header that makes it work.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Lee20y ago
Okay, I found the solution.

To download:
Response.ContentType = dsPDF.Tables[0].Rows[0]["strPDFFileWordMime"].ToString();

Response.OutputStream.Write((byte[])dsPDF.Tables[0].Rows[0]["imgPDFFileWordDoc"],0,Convert.ToInt32(dsPDF.Tables[0].Rows[0]["intPDFFileWordLength"]));

Response.AddHeader("Content-Disposition","attachment;filename=" + dsPDF.Tables[0].Rows[0]["strPDFFileWordName"].ToString());

Response.Flush();

Response.End();
and to Display:

Response.ContentType = dsPDF.Tables[0].Rows[0]["strPDFFileWordMime"].ToString();

Response.OutputStream.Write((byte[])dsPDF.Tables[0].Rows[0]["imgPDFFileWordDoc"],0,Convert.ToInt32(dsPDF.Tables[0].Rows[0]["intPDFFileWordLength"]));

Response.AddHeader("Content-Disposition", "inline;filename=" + dsPDF.Tables[0].Rows[0]["strPDFFileWordName"].ToString());

Response.Flush();

Response.End();

it's the word inline in the header that makes it work.