使用ASP.NET上传多个文件到数据库

最新推荐文章于 2018-05-20 08:36:00 发布

原创最新推荐文章于 2018-05-20 08:36:00 发布 · 2.9k 阅读

8 ·

CC 4.0 BY-SA版权

文章标签：

#asp.net #asp #server #stylesheet #download #object

ASP.NET 2.0 专栏收录该内容

14 篇文章

订阅专栏

本文介绍了一种在ASP.NET中实现多文件上传至数据库的方法，并提供了完整的客户端与服务器端代码示例，同时还包括了从数据库下载文件的功能。

如果仅仅是上传一个文件,最好是使用FileUpload控件, 可以使用FileUpload1.FileContent.Length得到文件大小, FileUpload1.FileBytes得到其字节数组, 代码略.

如果要上传多个文件, 其客户端代码与使用ASP.NET上传多个文件到服务器基本相同, 本例中加入了下载的示例代码。

效果图如下:

多文件上传到数据库

数据库脚本

create database FileDB
go
use FileDB
go
create table dbo.Files
(
	id int identity primary key
	,FileName varchar(50) not null
	,FileSize int not null
	,FileData image not null
	--,UpTime DateTime default getdate()
	--,DownLoadTimes int default 0
)
go

页面代码:MutlileFileUploadToDB.aspx

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="MutlileFileUploadToDB.aspx.cs" Inherits="MutlileFileUploadToDB" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <title>多文件上传到数据库Demo</title> <link href="css/writemail.css" mce_href="css/writemail.css" rel="stylesheet" type="text/css" /> <mce:script type="text/javascript"></mce:script> </head> <body> <form id="form1" runat="server" > <div> <a id="addAttach_a" onclick="return addAttach(false);" href="#" mce_href="#" class="add_attach">添加附件</a> <div id="files"></div> <asp:Button ID="btnSend" runat="server" Text="发送" onclick="btnSend_Click" /> <asp:GridView ID="gvwFiles" runat="server" AutoGenerateColumns="False" DataKeyNames="id" DataSourceID="sdsFiles" onrowcommand="gvwFiles_RowCommand"> <Columns> <asp:BoundField DataField="FileName" HeaderText="FileName" SortExpression="FileName" /> <asp:BoundField DataField="FileSize" HeaderText="FileSize" SortExpression="FileSize" /> <asp:TemplateField> <ItemTemplate> <asp:LinkButton ID="lbtnDownload" runat="server" CommandName="download" CommandArgument='<%#Eval("FileName") %>'>下载</asp:LinkButton> </ItemTemplate> </asp:TemplateField> </Columns> </asp:GridView> <asp:SqlDataSource ID="sdsFiles" runat="server" ConnectionString="<%$ ConnectionStrings:FileDBConnectionString %>" DataSourceMode="DataReader" ProviderName="<%$ ConnectionStrings:FileDBConnectionString.ProviderName %>" SelectCommand="SELECT [id], [FileName], [FileSize] FROM [Files]"> </asp:SqlDataSource> </div> </form> </body> </html>

后台代码:MutlileFileUploadToDB.aspx.cs

using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.IO; using System.Data.SqlClient; public partial class MutlileFileUploadToDB : System.Web.UI.Page { protected void Page_Load(object sender, System.EventArgs e) { //告诉表单如何格式化文件信息 Page.Form.Enctype = "multipart/form-data"; } protected void btnSend_Click(object sender, EventArgs e) { for (int index = 0; index < Request.Files.Count; index++) { HttpPostedFile file = Request.Files[index]; if (!string.IsNullOrEmpty(file.FileName)) { byte[] fileBytes = new byte[file.ContentLength]; file.InputStream.Read(fileBytes, 0, file.ContentLength); using (SqlConnection cn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["FileDBConnectionString"].ConnectionString)) { SqlCommand cmd = new SqlCommand("insert into Files(FileName, FileSize, FileData) values(@fileName, @fileSize, @fileData)", cn); cmd.Parameters.AddWithValue("@fileName", Path.GetFileName(file.FileName)); cmd.Parameters.AddWithValue("@fileSize", file.ContentLength); cmd.Parameters.AddWithValue("@FileData", fileBytes); cn.Open(); cmd.ExecuteNonQuery(); } } } gvwFiles.DataBind(); } protected void gvwFiles_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "download") { byte[] fileData = null; using (SqlConnection cn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["FileDBConnectionString"].ConnectionString)) { SqlCommand cmd = new SqlCommand("select FileData from files where id = @id", cn); int index = ((e.CommandSource as LinkButton).NamingContainer as GridViewRow).RowIndex; cmd.Parameters.AddWithValue("@id", gvwFiles.DataKeys[index].Value); cn.Open(); fileData = cmd.ExecuteScalar() as byte[]; } if (fileData == null) { Response.StatusCode = 404; } else { //使用Content-Disposition会有些缺点，在不同的浏览器中文件名显示有些不正常，如果用FireFox就无须编码 Response.AddHeader("Content-Disposition", "attachment; filename=/"" + HttpUtility.UrlEncode(e.CommandArgument.ToString(), System.Text.Encoding.UTF8) + "/""); Response.BinaryWrite(fileData); } Response.End(); } } }