下载文件从数据库的OracleBlob类型的字段

if (dr.Read())
{
OracleBlob myblob_ = dr.GetOracleBlob(1);
if (myblob_ != OracleClob.Null)
try
{
myblob_.Position = 0;
buf = new byte[myblob_.Length];
myblob_.Read(buf, 0, (int)myblob_.Length);
base.Response.Buffer = false;
Response.AddHeader("Connection", "Keep-Alive");
Response.ContentType = "application/octet-stream";
Response.AddHeader("Content-Disposition", "inline;filename=" + System.Web.HttpUtility.UrlEncode(Article_title, System.Text.Encoding.UTF8));
Response.AddHeader("Content-Disposition", "attachment;filename=" + System.Web.HttpUtility.UrlEncode(dr["resource_name"].ToString(), System.Text.Encoding.UTF8));
Response.AddHeader("Content-Length", buf.Length.ToString());
Response.OutputStream.Write(buf, 0, buf.Length);
Response.End();
/*
FileStream sw;
sw = File.Create("D:\\WebSites\\simple\\" + dr["article_caption"].ToString());
sw.Write(buf, 0, (int)myblob_.Length);
sw.Close();
*/
}
catch (Exception exp)
{

}
finally
{
db.Close();
}
}
else;
}

转载于:https://www.cnblogs.com/luanlin/archive/2006/09/09/499431.html