从Oracle的Blob字段中下载文件

思路：从Blob字段中获取byte数组，然后将byte数组输出到客户端，注意设置网页的Header

代码如下：

 1 string constr = System.Configuration.ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
 2 string sqlstr = "select file_name,FILECONTENT from fjg_file_manage where numbers='" + FileNum + "'";
 3 OracleConnection conn = new OracleConnection(constr);
 4 OracleCommand cmd = new OracleCommand(sqlstr, conn);
 5 
 6 conn.Open();
 7 OracleDataReader dr = cmd.ExecuteReader();
 8 dr.Read();
 9 //由于文件名中有空格，下载后空格会变成加号（+），因此需要进行特殊处理
10 string fileName = HttpUtility.UrlEncode(fileName,Encoding.UTF8);   //编码后空格会变成加号
11 fileName = fileName.Replace("+", "%20"); //将加号替换为空格
12 //一定要设置好header，不然网页中不会弹出下载框
13 HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment;filename=" + fileName);
14 HttpContext.Current.Response.ContentType = "application/octet-stream";
15 context.Response.BinaryWrite((byte[])dr["FILECONTENT"]);
16 conn.Close();

转载于:https://www.cnblogs.com/neverstop/archive/2012/11/07/2759335.html