FileUpLoad图片预览、保存图片到数据库

一.FileUpLoad实现图片的预览

 

<style type="text/css">
  #image{

   //这里是滤镜的操作
  FILTER: progid:DXImageTransform.Microsoft.AlphaImageLoader(sizingMethod=scale)
  }
</style>

<script type="text/javascript">

 

 

//FileUpload控件及显示图片的地方
<asp:FileUpload ID="FileUpload1" runat="server"  Width="221px" οnchange="Preview(this)"/>
<div id="image">这里是显示图片的地方</div>

 

一.保存图片到数据库

   图片打开之后点击更新按钮，实现新图片导入到数据库

  string strConnection;
  strConnection = ConfigurationManager.ConnectionStrings["DBConnectionString"].ToString();

  OleDbConnection  connection = new OleDbConnection(strConnection);
  OleDbCommand   cmd = new OleDbCommand("", connection);
   connection.Open();

    protected void Button1_Click(object sender, EventArgs e)
    {
        byte[] fileData = this.FileUpload1.FileBytes;//FileUpload图片转为二进制
        OleDbParameter para = new OleDbParameter("@P1", SqlDbType.Image);

        //实现数据库中图片的更新
        string query= "update CmpName set image =?" + " where cmpname='" + strCmpName + "'";
        cmd.CommandText =query;
        para.Value = fileData;
        cmd.Parameters.Add(para);
        cmd.ExecuteNonQuery();

         //从数据库中取出图片，strCmpName是图片唯一的编号
        //this.Image1.ImageUrl = "GetImage.aspx?id=" + strCmpName;
        ShowMessage("图片更新成功");

    }

 

//以下是GetImage.aspx取出图片的内容

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.OleDb;

using System.IO;

using System.Drawing;

public partial class GetImage : System.Web.UI.Page
{
    protected OleDbConnection connection;
    protected OleDbCommand cmd;
    protected OleDbDataAdapter da;
    protected DataSet ds;
    protected void Page_Load(object sender, EventArgs e)
    {
        string id= Request.QueryString["id"];
        string sql = "select image from CmpName where cmpname='" +id +"'";
        string strConnection;
        strConnection = ConfigurationManager.ConnectionStrings["DBConnectionString"].ToString();

        connection = new OleDbConnection(strConnection);
        cmd = new OleDbCommand(sql, connection);

        connection.Open();
        byte[] fileData = (byte[])cmd.ExecuteScalar();
        connection.Close();

        MemoryStream ms = new MemoryStream(fileData);
        Image img = Image.FromStream(ms);
        img.Save(Response.OutputStream, Imaging.ImageFormat.JPEG);

    }
}

 

function Preview(imgFile)
{
  var divimage = document.getElementById("image");
  divimage .filters.item("DXImageTransform.Microsoft.AlphaImageLoader").src = imgFile.value;
}