ASP.NET(C#) 实现将图片以二进制保存到数据库中转

最新推荐文章于 2024-09-14 19:55:29 发布

2004v2004

最新推荐文章于 2024-09-14 19:55:29 发布

阅读量2.9k

点赞数 1

文章标签：数据库 asp.net c# button javascript exception

本文链接：https://blog.csdn.net/2004v2004/article/details/4101502

版权

注意:上传大文件时,会出现错误,原因我现在还不知道.

数据库名:mydata

表名:table_img

字段:id 自动编号

filename 文本

img OLE 对象

default.aspx

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

</body>
</html>

default.aspx.cs

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;
using System.IO;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

}

    protected void Button1_Click(object sender, EventArgs e)
    {
        try
        {
            if (FileUpload1.HasFile)
            {
                if (IsAllowedExtension(this.FileUpload1))
                {
                    //取得上传文件的大小
                    int FileLen = FileUpload1.PostedFile.ContentLength;

Byte[] FileData = new Byte[FileLen];

//创建访问客户端上传文件的对象
HttpPostedFile hp = FileUpload1.PostedFile;

//创建数据流对象
Stream sr = hp.InputStream;

                    //将图片数据放到FileData数组对象实例中，0代表数组指针的起始位置,FileLen代表指针的结束位置
                    sr.Read(FileData, 0, FileLen);
                    string strdatapath = "Provider = Microsoft.JET.OleDB.4.0;Data Source = " + Server.MapPath("mydata.mdb");
                    OleDbConnection conn = new OleDbConnection(strdatapath);
                    conn.Open();
                    OleDbCommand cmd = new OleDbCommand("insert into table_img(filename,img) values(filename,img)", conn);

                    //存储过程插入到数据库中
                    OleDbParameter para1 = new OleDbParameter("filename", OleDbType.VarChar);
                    para1.Value = "FileData";
                    cmd.Parameters.Add(para1);
                    //存储过程插入到数据库中
                    OleDbParameter para = new OleDbParameter("img", OleDbType.Binary);
                    para.Value = FileData;
                    cmd.Parameters.Add(para);
                    cmd.ExecuteNonQuery();

                    //弹出上传成功的提示
                    Response.Write("<script>alert('上传成功');</script>");
                  // Response.Write("<script languge = ‘javascript‘ type = ‘text/javascript‘>alert(‘上传成功‘);</script>");

//关闭数据库连接
conn.Close();

                }
                else
                {
                    Response.Write("<script>alert('上传文件格式不对,只允许上传jpg和gif格式的文件');</script>");
                  // Response.Write("<script languge = ‘javascript‘ type = ‘text/javascript‘>alert(‘上传文件格式不对,只允许上传jpg和gif格式的文件‘);</script>");
                }
            }
            else
            {
                Response.Write("<script>alert('请选择上传文件');</script>");
               // Response.Write("<script language = ‘javascript‘ type = ‘text/javascript‘>alert(‘请选择上传文件‘);</script>");
            }
        }
        catch (Exception ex)
        {
              Response.Write(ex.Message);
            throw new Exception(ex.Message + "数据库连接失败");
        }

}

    #region 实现真正意义上的文件类型判断
    public static bool IsAllowedExtension(FileUpload hifile)
    {
        System.IO.FileStream fs = new System.IO.FileStream(hifile.PostedFile.FileName, System.IO.FileMode.Open, System.IO.FileAccess.Read);
        System.IO.BinaryReader r = new System.IO.BinaryReader(fs);
        string fileclass = "";
        byte buffer;
        try
        {
            buffer = r.ReadByte();
            fileclass = buffer.ToString();
            buffer = r.ReadByte();
            fileclass += buffer.ToString();

        }
        catch
        {
        }
        r.Close();
        fs.Close();
        if (fileclass == "255216" || fileclass == "7173")//说明255216是jpg;7173是gif;6677是BMP,13780是PNG;7790是exe,8297是rar
        {
            return true;
        }
        else
        {
            return false;
        }
    }
    #endregion

}

显示图片

protected void Button2_Click(object sender, EventArgs e)
{
// 在此处放置用户代码以初始化页面

show(); //显示图片

    }
    public void show()
    {
        string strdatapath = "Provider = Microsoft.JET.OleDB.4.0;Data Source = " + Server.MapPath("mydata.mdb");
        OleDbConnection conn = new OleDbConnection(strdatapath);
       // conn.Open();
        string ss = "1";// Request.QueryString["id"].ToString();
        string s3 = "select * from table_img where id=" + ss;
        OleDbCommand comm = new OleDbCommand(s3, conn);
        conn.Open();
        OleDbDataReader dr = comm.ExecuteReader(CommandBehavior.CloseConnection);
        while (dr.Read())
        {
            Response.Clear();
          // Response.C;
            Response.BinaryWrite((byte[])dr["img"]);//读取
        }
        Response.End();
        conn.Close();
    }