SqlDataReader dr = null;
string filename = "test.doc";//这个就是要存放到服务器的文件名
using (SqlConnection con = new SqlConnection("Data Source=localhost;database=test;uid=sa;pwd=123"))
{
con.Open();
using (SqlCommand cmd = con.CreateCommand())
{
cmd.CommandText = "select files from T_files where id=5";
dr = cmd.ExecuteReader();
byte[] File = null;
if (dr.Read())
{
File = (byte[])dr[0];
}
Response.Buffer = true;
Response.ContentType = "application/octet-stream";
Response.AddHeader("Content-Disposition", "attachment;filename=" + filename);
FileStream fs = new FileStream(Server.MapPath("~/LoadDown") + @"/" + filename, FileMode.OpenOrCreate);
BinaryWriter bw = new BinaryWriter(fs);
bw.Write(File, 0, File.Length);
Response.OutputStream.Write(File, 0, File.Length);
Response.OutputStream.Flush();
Response.OutputStream.Close();
Response.Flush();
Response.End();
}
}
ASP.NET 中实现 读取数据库二进制word并下载
最新推荐文章于 2021-01-26 16:22:59 发布