Asp.Net上传文件到Access数据中,并从数据库中读取文件并保存

OStack程序员社区-中国程序员成长平台 › 门户 › 编程› ASP.NET›ASP.NET编程经验

原作者: [db:作者] 来自: [db:来源] 收藏邀请

首先在Access中建立一个表结构为:
表名:img

字段名             字段类型              说明
ID                    自动编号              系统分配ID值
Imgtype           文本                     上传文件类型
imgdata          OLE对象                上传文件数据

aspx 页面主要代码

<form id="form1" runat="server">
    <div>
        <asp:FileUpload ID="FileUpload1" runat="server" Width="345px" />
        <asp:Button ID="Button1" runat="server"
            Text="上传到数据库" onclick="Button1_Click" />
        <asp:Button ID="Button2" runat="server" Text="读取数据库到文件"
            onclick="Button2_Click" /><asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
    </div>
    </form>

Cs文件代码

System.Data.OleDb.OleDbConnection conn = new System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Password=;User ID=admin;Data Source=D:\\WEB\\MyVs2008\\MyVs2008\\App_Data\\supervod.mdb");
protected void Button1_Click(object sender, EventArgs e)
        {
            if (!IsValid) return;
            if (FileUpload1.PostedFile.FileName != "")
            {
                int datalength = this.FileUpload1.PostedFile.ContentLength; //获取上传文件大小
                byte[] databuffer = new byte[datalength]; //建立文件字节数组,缓存空间
                System.IO.Stream objstream = this.FileUpload1.PostedFile.InputStream;
                objstream.Read(databuffer, 0, datalength);
                string ext = System.IO.Path.GetExtension(FileUpload1.PostedFile.FileName);
                System.Data.OleDb.OleDbCommand cmd = new System.Data.OleDb.OleDbCommand();
                cmd.Connection = conn;
                cmd.CommandText = "insert into img(imgtype,imgdata) values(@imgtype,@imgdata)";
                cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@imgtype", System.Data.OleDb.OleDbType.VarChar)).Value = ext;
                cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@imgdata", System.Data.OleDb.OleDbType.Binary)).Value = databuffer;
                conn.Open();
                cmd.ExecuteNonQuery();
                conn.Close();
            }
        }

        protected void Button2_Click(object sender, EventArgs e)
        {
            System.Data.OleDb.OleDbDataReader dr = null;
            System.Data.OleDb.OleDbCommand cmd = new System.Data.OleDb.OleDbCommand();
            byte[] FileData=null;
            string type="";
            cmd.CommandText = "select imgdata,imgtype from img where id=@ID";
            cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@ID", System.Data.OleDb.OleDbType.Integer)).Value = TextBox1.Text.Trim();
            cmd.Connection = conn;
            conn.Open();
            dr = cmd.ExecuteReader();
            if (dr.Read())
            {
                FileData = (byte[])dr["imgdata"];
                type=dr["imgtype"].ToString();
            }
            dr.Close();
            conn.Close();
            System.IO.FileStream fs = new System.IO.FileStream("d:\\aaa" + type, System.IO.FileMode.Create);
            System.IO.BinaryWriter bw = new System.IO.BinaryWriter(fs);
            bw.Write(FileData, 0, FileData.Length);
            bw.Close();
        }

代码很简单,这里只做了一个演示,保存文件名为固定名称,其实可以在数据库里加入一个文件名了字段,这样就可以解决