asp.net从数据库里读取二进制文件

public void SqlToFile() { string sql = @"SELECT FileName,FileType,FileRes FROM UpdateFileRes left outer join UpdateFiles on UpdateFileRes.ID=UpdateFiles.ID WHERE UpdateFileRes.ID= 103 "; SqlCommand cmd = new SqlCommand(sql, myConn); cmd.Connection.Open(); SqlDataReader dr = cmd.ExecuteReader(); if (!dr.HasRows) { Response.Write(""); return; } dr.Read(); byte[] FileArray = (byte[])dr[2]; string filetype = dr[1].ToString();//文件类型 string filename = dr[0].ToString();//文件名 cmd.Dispose(); dr.Close(); cmd.Connection.Close(); Response.Buffer = true; Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8"); Response.Clear(); Response.ContentType = filetype; Response.AddHeader("Content-Disposition", "attachment;filename=" + System.Web.HttpUtility.UrlEncode(filename, System.Text.Encoding.UTF8)); Response.BinaryWrite(FileArray); Response.Flush(); Response.End(); }