string strTemp = System.Web.HttpUtility.UrlEncode(strName, System.Text.Encoding.UTF8);//解決檔案名稱亂碼
protected string strConn = Common.Config.GetAppSettingsKeyValue("DBConnectString");
protected System.Data.OleDb.OleDbConnection conn;
protected System.Data.OleDb.OleDbCommand cmd;
protected System.Data.OleDb.OleDbDataReader dr;
private void Download(string field, string id)
{
try
{
string strCmd = "select * from doc_body where id = " + id;
conn = new OleDbConnection(strConn);
cmd = new OleDbCommand(strCmd,conn);
conn.Open();
dr = cmd.ExecuteReader();
dr.Read();
int nSize = (int)dr["doc_size"];
string strContentType = (string)dr["ContentType"];
string strName = (string)dr["doc_name"];
byte [] data = (byte[])dr[field];
if(nSize == 0)
{
message.Text = "<font color=#0000ff>沒有檔案下載!</font>";
}
else
{
Response.Clear();
Response.Buffer = true;
//Response.Charset = "utf-8";
//Response.ContentEncoding=System.Text.Encoding.GetEncoding("utf-8");
//utf-8,gb2312,big5
Response.ContentType = strContentType;
//application/ms-excel,application/ms-word,application/ms-txt,application/ms-html或其他瀏覽器可直接支援文檔
string strTemp = System.Web.HttpUtility.UrlEncode(strName, System.Text.Encoding.UTF8);//解決檔案名稱亂碼
Response.AppendHeader("content-disposition", "attachment;filename=" + strTemp);//附件下載
//Response.AppendHeader("content-disposition", "online;filename=" + strName);//線上開啟
Response.OutputStream.Write(data, 0, nSize);
}
}
catch(Exception exp)
{
Common.utility.MessageBox(this,"下載失敗!\n錯誤資訊:\n"+exp.Message);
}
finally
{
conn.Close();
}
}