CREATE TABLE BlobStore (
Id INT IDENTITY(1,1) PRIMARY KEY,
Name NVARCHAR(255) NOT NULL, -- 原始檔名
Type NVARCHAR(100) NOT NULL, -- MIME 類型
Data VARBINARY(MAX) NOT NULL -- 檔案二進位內容
);
使用 VARBINARY(MAX) 取代舊版 IMAGE,支援 2GB 以上大檔案。
private void btnUpload_Click(object sender, EventArgs e) {
if (fileUpload.PostedFile == null || fileUpload.PostedFile.ContentLength == 0) return;
var stream = fileUpload.PostedFile.InputStream;
var len = fileUpload.PostedFile.ContentLength;
var mime = fileUpload.PostedFile.ContentType;
var name = Path.GetFileName(fileUpload.PostedFile.FileName);
byte[] buffer = new byte[len];
stream.Read(buffer, 0, len);
const string connStr = "Server=.;Database=DocDB;Integrated Security=true;";
using (var conn = new SqlConnection(connStr))
using (var cmd = new SqlCommand("INSERT INTO BlobStore (Name, Type, Data) VALUES (@Name, @Type, @Data)", conn)) {
cmd.Parameters.Add("@Name", SqlDbType.NVarChar, 255).Value = name;
cmd.Parameters.Add("@Type", SqlDbType.NVarChar, 100).Value = mime;
cmd.Parameters.Add("@Data", SqlDbType.VarBinary, -1).Value = buffer; // -1 = MAX
conn.Open();
cmd.ExecuteNonQuery();
}
}
<asp:GridView ID="gvFiles" runat="server" AutoGenerateColumns="False" DataKeyNames="Id">
<Columns>
<asp:BoundField DataField="Name" HeaderText="檔案名稱" />
<asp:BoundField DataField="Type" HeaderText="類型" />
<asp:HyperLinkField DataNavigateUrlFields="Id" DataNavigateUrlFormatString="Download.aspx?id={0}"
Text="下載" HeaderText="操作" />
</Columns>
</asp:GridView>
protected void Page_Load(object sender, EventArgs e) {
if (IsPostBack) return;
const string connStr = "Server=.;Database=DocDB;Integrated Security=true;";
using (var conn = new SqlConnection(connStr))
using (var cmd = new SqlCommand("SELECT Id, Name, Type FROM BlobStore", conn))
using (var da = new SqlDataAdapter(cmd)) {
var dt = new DataTable();
da.Fill(dt);
gvFiles.DataSource = dt; gvFiles.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e) {
string id = Request.QueryString["id"];
if (string.IsNullOrEmpty(id)) return;
const string connStr = "Server=.;Database=DocDB;Integrated Security=true;";
using (var conn = new SqlConnection(connStr))
using (var cmd = new SqlCommand("SELECT Name, Type, Data FROM BlobStore WHERE Id = @Id", conn)) {
cmd.Parameters.Add("@Id", SqlDbType.Int).Value = int.Parse(id);
conn.Open();
using (var dr = cmd.ExecuteReader(CommandBehavior.SequentialAccess)) { // 關鍵:大檔案串流
if (dr.Read()) {
string name = dr.GetString(0);
string mime = dr.GetString(1);
// 串流輸出,避免大檔案佔用記憶體
Response.Clear();
Response.Buffer = false; // 關閉緩衝,直接串流
Response.ContentType = mime;
Response.AddHeader("Content-Disposition", $"attachment; filename=\"{HttpUtility.UrlEncode(name, Encoding.UTF8)}\"");
// 使用 GetBytes 串流讀取 (或 GetStream .NET 4.5+)
long offset = 0; const int chunk = 8192; byte[] buffer = new byte[chunk];
long bytesRead;
while ((bytesRead = dr.GetBytes(2, offset, buffer, 0, chunk)) > 0) {
Response.OutputStream.Write(buffer, 0, (int)bytesRead);
offset += bytesRead;
Response.Flush();
}
Response.End();
}
}
}
}
GetBytes 串流讀取,避免將整個 Blob 載入記憶體。Response.Flush():即時串流輸出,支援超大檔案下載不 Timeout。HttpUtility.UrlEncode(name, Encoding.UTF8) 解決中文檔名在瀏覽器下載對話框顯示亂碼。ContentType,下載時原樣輸出,瀏覽器自動識別處理方式。SHA256 雜湊欄位,支援去重、完整性驗證。此架構已在多個企業文件管理系統中穩定運行,支援 Word、Excel、PDF、圖片等任意二進位檔案儲存與下載。