图片的二进制数据库存储和显示

GridView控件 Image控件 与图片的二进制数据库存储和显示1.将图片以二进制存入数据库2.读取二进制图片在页面显示3.设置Image控件显示从数据库中读出的二进制图片4.GridView中ImageField以URL方式显示图片5.GridView显示读出的二进制图片====================1.将图片以二进制存入数据库--------------------------//保存图片到数据库protected void Button1_Click(object sender, EventArgs e){    //图片路径    string strPath = "~/photo/03.JPG";    string strPhotoPath = Server.MapPath(strPath);     ////////////这里的Server.MapPath()就是将上传的图片保存到***地址/////////////////    //读取图片    FileStream fs = new System.IO.FileStream(strPhotoPath, FileMode.Open, FileAccess.Read);    BinaryReader br = new BinaryReader(fs);     byte[] photo = br.ReadBytes((int)fs.Length);     br.Close();     fs.Close();     //存入    SqlConnection myConn = new SqlConnection("Data Source=127.0.0.1;Initial Catalog=TestDB;User ID=sa;Password=sa");    string strComm = " INSERT INTO personPhoto(personName, personPhotoPath, personPhoto) ";    strComm += " VALUES('wangwu', '" + strPath + "', @photoBinary )";    SqlCommand myComm = new SqlCommand(strComm, myConn);    myComm.Parameters.Add("@photoBinary", SqlDbType.Binary,photo.Length);    myComm.Parameters["@photoBinary"].Value = photo;    myConn.Open();    myComm.ExecuteNonQuery();    myConn.Close();}2.读取二进制图片在页面显示--------------------------//读取图片SqlConnection myConn = new SqlConnection("Data Source=127.0.0.1;Initial Catalog=TestDB;User ID=sa;Password=sa");string strComm = " SELECT personPhoto FROM personPhoto WHERE personName='wangwu' ";SqlCommand myComm = new SqlCommand(strComm, myConn);myConn.Open();SqlDataReader dr = myComm.ExecuteReader();while (dr.Read()){    byte[] photo = (byte[])dr["personPhoto"];    this.Response.BinaryWrite(photo);}dr.Close();myConn.Close();或SqlConnection myConn = new SqlConnection("Data Source=127.0.0.1;Initial Catalog=TestDB;User ID=sa;Password=sa");SqlDataAdapter myda = new SqlDataAdapter(" SELECT personPhoto FROM personPhoto WHERE personName='wangwu' ", myConn);DataSet myds = new DataSet();myConn.Open();myda.Fill(myds);myConn.Close();//byte[] photo = (byte[])myds.Tables[0].Rows[0]["personPhoto"];this.Response.BinaryWrite(photo);3.设置Image控件显示从数据库中读出的二进制图片---------------------------------------------SqlConnection myConn = new SqlConnection("Data Source=192.168.0.36;Initial Catalog=TestDB;User ID=sa;Password=sa");SqlDataAdapter myda = new SqlDataAdapter(" SELECT personPhoto FROM personPhoto WHERE personName='wangwu' ", myConn);DataSet myds = new DataSet();myConn.Open();myda.Fill(myds);myConn.Close();//byte[] photo = (byte[])myds.Tables[0].Rows[0]["personPhoto"];//图片路径string strPath = "~/photo/wangwu.JPG";string strPhotoPath = Server.MapPath(strPath);//保存图片文件BinaryWriter bw = new BinaryWriter(File.Open(strPhotoPath,FileMode.OpenOrCreate));bw.Write(photo);bw.Close();//显示图片this.Image1.ImageUrl = strPath;4.GridView中ImageField以URL方式显示图片----------------------------<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False">    <Columns>        <asp:BoundField DataField="personName" HeaderText="姓名" />        <asp:ImageField DataImageUrlField="personPhotoPath"             HeaderText="图片">        </asp:ImageField>    </Columns></asp:GridView>后台直接绑定即可5.GridView显示读出的二进制图片------------------------------//样板列<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" OnRowDataBound="GridView1_RowDataBound">    <Columns>        <asp:BoundField DataField="personName" HeaderText="姓名" />        <asp:ImageField DataImageUrlField="personPhotoPath"             HeaderText="图片">        </asp:ImageField>        <asp:TemplateField HeaderText="图片">            <ItemTemplate>                <asp:Image ID="Image1" runat="server" />            </ItemTemplate>        </asp:TemplateField>    </Columns></asp:GridView>//绑定protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e){    if (e.Row.RowIndex < 0)        return;    // System.ComponentModel.Container    string strPersonName = (string)DataBinder.Eval(e.Row.DataItem, "personName");    Image tmp_Image = (Image)e.Row.Cells[2].FindControl("Image1");    if (!System.Convert.IsDBNull(DataBinder.Eval(e.Row.DataItem, "personPhoto")))    {        //        byte[] photo = (byte[])DataBinder.Eval(e.Row.DataItem, "personPhoto");        //图片路径        string strPath = "~/photo/" + strPersonName.Trim() + ".JPG";        string strPhotoPath = Server.MapPath(strPath);        //保存图片文件        BinaryWriter bw = new BinaryWriter(File.Open(strPhotoPath, FileMode.OpenOrCreate));        bw.Write(photo);        bw.Close();        //显示图片        tmp_Image.ImageUrl = strPath;    }    }***************************#region 相册Grid按钮事件 protected void gv_PhotoInfo_RowCommand(object sender, GridViewCommandEventArgs e) { GridViewRow currRow = (GridViewRow)((Button)e.CommandSource).Parent.Parent; string strPhotoID = currRow.Cells[0].Text.ToString(); string strPhotoName = currRow.Cells[1].Text.ToString(); if (e.CommandName == "btn_Edit")//照片属性修改 { Response.Redirect("PhotoEdit.aspx?PhotoID=" + strPhotoID + "&PhotoName=" + strPhotoName); } else if (e.CommandName == "btn_Detail")//照片内容查看 { this.img1.Src = "PhotoShow.aspx?PhotoID=" + strPhotoID; this.img1.Visible = true; } else if (e.CommandName == "btn_Delete")//照片删除 { } } #endregionPhotoShow.aspx页面 =============== using System; using System.Data; using System.Configuration; using System.Collections; 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.SqlClient; using System.IO; public partial class PhotoShow : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { try { #region 原图 //int intPhotoID = Convert.ToInt32(Request.QueryString["PhotoID"].Trim()); //string strSql = " SELECT PhotoContent FROM PhotoInfo "; //strSql += " WHERE PhotoID = " + intPhotoID + " "; //DataTable dt = DBClass.RunSelectGetDataTable(strSql); //byte[] photo = (byte[])dt.Rows[0]["PhotoContent"]; //this.Response.BinaryWrite(photo); #endregion #region 规定宽高的图 //int intPhotoID = Convert.ToInt32(Request.QueryString["PhotoID"].Trim()); int intPhotoID = 1; //int intHeight = Request.QueryString["PhotoHeight"].Trim(); int intHeight = 500; //int intWidth = Request.QueryString["PhotoWidth"].Trim(); int intWidth =500; string strSql = " SELECT PhotoContent FROM PhotoInfo "; strSql += " WHERE PhotoID = " + intPhotoID + " "; DataTable dt = DBClass.RunSelectGetDataTable(strSql); byte[] photo = (byte[])dt.Rows[0]["PhotoContent"]; //this.Response.BinaryWrite(photo); System.IO.MemoryStream ms = new MemoryStream(photo); System.Drawing.Image img = System.Drawing.Image.FromStream(ms); System.Drawing.Image newImg = img.GetThumbnailImage(intWidth, intHeight, null, new System.IntPtr()); newImg.Save(Response.OutputStream, System.Drawing.Imaging.ImageFormat.Gif); #endregion } catch(Exception ex) { } } }*************************#region 上传 按钮 事件 protected void btn_Upload_Click(object sender, EventArgs e) { using (SqlConnection sqlConn = new SqlConnection(DBClass.DBConnString())) { sqlConn.Open(); int intImageSize; string strImageType; Stream ImageStream; intImageSize = this.FileUpload1.PostedFile.ContentLength; ImageStream = this.FileUpload1.PostedFile.InputStream; strImageType = this.FileUpload1.PostedFile.ContentType; Byte[] ImageContent = new Byte[intImageSize]; int intStatus; intStatus = ImageStream.Read(ImageContent, 0, intImageSize); String strSql = "INSERT INTO PhotoInfo( AlbumID, PhotoName, PhotoType "; strSql += " , PhotoContent, PhotoByteSize, PhotoNote )"; strSql += " VALUES( '" + Request.QueryString["AlbumID"].Trim() + "' "; strSql += " ,'" + this.txt_PhotoName.Text.Trim() + "' "; strSql += " ,'" + this.FileUpload1.PostedFile.ContentType + "' "; strSql += " ,@photoBinary "; strSql += " ," + this.FileUpload1.PostedFile.ContentLength + " "; strSql += " ,'" + this.txt_PhotoNote.Text.Trim() + "' "; strSql += " ) "; SqlCommand sqlComm = new SqlCommand(strSql, sqlConn); sqlComm.Parameters.Add("@photoBinary", SqlDbType.Image, intImageSize); sqlComm.Parameters["@photoBinary"].Value = ImageContent; sqlComm.ExecuteNonQuery(); sqlConn.Close(); } CommonHelper.DoAlert(this.Page, "上传成功"); this.txt_PhotoName.Text = ""; this.txt_PhotoNote.Text = ""; } #endregion