ASP.NET2.0中將資料庫欄位中儲存的檔案顯示出來

 在web應用中有時要求將儲存在欄位中的檔案顯示出來,這些檔案以BLOB方式存在資料庫中。顯示時吐出到用戶端瀏覽器。下面是範例程式碼。表名是ATTACHMENTS ,BLOB欄位名ATTACHMENT_CONTENT。

<%@ Page Language="C#" EnableTheming="false" ValidateRequest="false" StylesheetTheme=""%>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Configuration" %>
<%@ Import Namespace="System.Collections" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<%@ Import Namespace="System.IO" %>
<%
    SqlConnection conn;
    SqlCommand comm;

    string sID = Request.QueryString["sID"].ToString();
    conn = new SqlConnection();
    comm = new SqlCommand();
    conn.ConnectionString = ConfigurationManager.ConnectionStrings["HS2005ConnectionString"].ConnectionString;
    comm.Connection = conn;
    conn.Open();
    comm.CommandText = @"SELECT ATTACHMENT_CONTENT,FILE_NAME,FILE_TYPE FROM ATTACHMENTS where ATTACHMENT_ID='" + sID + "'";
    SqlDataReader sdr = comm.ExecuteReader();
    if (sdr.Read())
    {
        Response.Clear();
        Response.ClearHeaders();
        string fn = sdr["FILE_NAME"].ToString();
        Response.Expires = 0;
        Response.Buffer = true;
        Response.Charset = "utf-8";
        this.EnableViewState = false;
        Response.ContentEncoding = System.Text.Encoding.UTF8;
        Response.ContentType = sdr["FILE_TYPE"].ToString();
        Response.AddHeader("Content-Disposition", "attachment;filename=" + fn);  //attachment改為inline則顯示在瀏覽器中。
        Response.ContentType = sdr["FILE_TYPE"].ToString();
        Response.BinaryWrite((byte[])sdr["ATTACHMENT_CONTENT"]);
    }
    sdr.Close();
    conn.Close();
%>
更多的內容：奧凱瑞爾