DataSet ds = new DataSet();
ds = GetFile();
if (ds.Tables[0].Rows.Count == 1)
{
string strContentType = ds.Tables[0].Rows[0]["FileType"].ToString();
Response.Charset = "";
Response.ContentType = strContentType;
Response.AppendHeader("Content-Type", strContentType);
int nlen = Int32.Parse(ds.Tables[0].Rows[0]["FileSize"].ToString());
if (nlen > 0)
{
byte[] myData = new byte[nlen];
myData = (byte[])ds.Tables[0].Rows[0]["CompanyBrochure"];
MemoryStream mstream = new MemoryStream(myData, 0, myData.Length);
Response.Clear();
Response.Buffer = true;
string fileName = "";
Response.AddHeader("Content-Disposition", "inline;filename=" + fileName);
Response.BinaryWrite(mstream.ToArray());
Response.Flush();
Response.End();
}
}