Asp.net 2.0(C#)图片存储到数据库和从数据库读取显示

最新推荐文章于 2021-03-18 17:29:24 发布

weixin_30765505

最新推荐文章于 2021-03-18 17:29:24 发布

阅读量139

点赞数

文章标签：数据库 ui xhtml

原文链接：http://www.cnblogs.com/cry/archive/2007/01/18/623973.html

版权

最近捣鼓了一下，效果就是这样：
图1：

图2：

ImageFileUpload.aspx：

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

<! 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 runat = " server " >

< title > 图片保存和显示 </ title >

</ head >

< body >

< form id = " Form2 " enctype = " multipart/form-data " runat = " server " >

< asp:Table ID = " Table1 " Runat = " server " Width = " 39% " BorderWidth = " 1 " BackColor = " Beige " >

< asp:TableRow runat = " server " >

< asp:TableCell ColumnSpan = " 2 " BackColor = " Red " runat = " server " >

< asp:Label ID = " Label1 " Font - size = " 12px " ForeColor = " White " font - bold = " True " Runat = " server " Text = " 添加 " Font - Names = " verdana " />

</ asp:TableCell >

</ asp:TableRow >

< asp:TableRow runat = " server " >

< asp:TableCell HorizontalAlign = " Right " runat = " server " >< asp:Label ID = " Label2 " Font - size = " 12px " Runat = " server " Text = " 名字 " Font - Names = " verdana " /></ asp:TableCell >

< asp:TableCell runat = " server " >< asp:TextBox id = " txtPersonName " Runat = " server " /></ asp:TableCell >

</ asp:TableRow >

< asp:TableRow runat = " server " >

< asp:TableCell HorizontalAlign = " Right " runat = " server " >< asp:Label ID = " Label3 " Font - size = " 12px " Runat = " server " Text = " Email " Font - Names = " verdana " /></ asp:TableCell >

< asp:TableCell runat = " server " >< asp:TextBox id = " txtPersonEmail " Runat = " server " /></ asp:TableCell >

</ asp:TableRow >

< asp:TableRow runat = " server " >

< asp:TableCell HorizontalAlign = " Right " runat = " server " >< asp:Label ID = " Label4 " Font - size = " 12px " Runat = " server " Text = " 性别 " Font - Names = " verdana " /></ asp:TableCell >

< asp:TableCell runat = " server " >

< asp:RadioButton GroupName = " sex " Font - Size = " 12px " Text = " 男性 " ID = " sexMale " Runat = " server " 　 Checked = " true " />

< asp:RadioButton GroupName = " sex " Font - Size = " 12px " Text = " 女性 " ID = " sexFeMale " Runat = " server " />

</ asp:TableCell >

</ asp:TableRow >

< asp:TableRow runat = " server " >

< asp:TableCell HorizontalAlign = " Right " runat = " server " >< asp:Label ID = " Label5 " Font - size = " 12px " Runat = " server " Text = " 生日 " Font - Names = " verdana " /></ asp:TableCell >

< asp:TableCell runat = " server " >< asp:TextBox id = " txtPersonDob " runat = " server " /></ asp:TableCell >

</ asp:TableRow >

< asp:TableRow runat = " server " >

< asp:TableCell HorizontalAlign = " Right " runat = " server " >< asp:Label ID = " Label6 " Font - size = " 12px " Runat = " server " Text = " 图片 " Font - Names = " verdana " /></ asp:TableCell >

< asp:TableCell runat = " server " >< input type = " file " id = " PersonImage " runat = " server " /></ asp:TableCell >

</ asp:TableRow >

< asp:TableRow runat = " server " >

< asp:TableCell ColumnSpan = " 2 " HorizontalAlign = " Center " runat = " server " >

< asp:Button ID = " Button1 " Text = " 添加 " OnClick = " AddPerson " runat = " server " />

</ asp:TableCell >

</ asp:TableRow >

</ asp:Table >

< br />

< table >

< tr >

< td align = " left " valign = " top " style = " width: 181px " >

< asp:Label ID = " Label_Message " runat = " server " Font - Size = " 10pt " ></ asp:Label ></ td >

< td style = " width: 7px " >

</ td >

< td align = " left " style = " width: 18px " valign = " top " >

</ td >

</ tr >

< tr >

< td style = " width: 181px; " align = " left " valign = " top " >

< asp:GridView ID = " GridView1 " runat = " server " AutoGenerateColumns = " False " CellPadding = " 4 " DataKeyNames = " PersonID " DataSourceID = " SqlDataSource_SelectImage " ForeColor = " #333333 " OnSelectedIndexChanged = " GridView1_SelectedIndexChanged " Font - Size = " 10pt " Width = " 200px " BackColor = " #FFE0C0 " >

< FooterStyle BackColor = " #507CD1 " Font - Bold = " True " ForeColor = " White " />

< Columns >

< asp:TemplateField HeaderText = " 序号 " InsertVisible = " False " SortExpression = " PersonID " >

< EditItemTemplate >

< asp:Label ID = " Label1 " runat = " server " Text = ' <%# Eval("PersonID") %> ' ></ asp:Label >

</ EditItemTemplate >

< ItemTemplate >

< asp:Label ID = " Label1 " runat = " server " Text = ' <%# Bind("PersonID") %> ' ></ asp:Label >

</ ItemTemplate >

< HeaderStyle Width = " 35px " />

</ asp:TemplateField >

< asp:BoundField DataField = " PersonName " HeaderText = " 名字 " SortExpression = " PersonName " />

< asp:BoundField DataField = " PersonImageType " HeaderText = " 图片类型 " SortExpression = " PersonImageType " />

< asp:CommandField ShowSelectButton = " True " >

< ItemStyle Width = " 30px " />

</ asp:CommandField >

</ Columns >

< RowStyle BackColor = " #EFF3FB " />

< EditRowStyle BackColor = " #2461BF " />

< SelectedRowStyle BackColor = " #D1DDF1 " Font - Bold = " True " ForeColor = " #333333 " />

< PagerStyle BackColor = " #2461BF " ForeColor = " White " HorizontalAlign = " Center " />

< HeaderStyle BackColor = " Red " Font - Bold = " True " ForeColor = " White " />

< AlternatingRowStyle BackColor = " White " />

</ asp:GridView >

</ td >

< td style = " width: 7px; height: 180px; " >

</ td >

< td align = " left " style = " width: 18px; height: 180px; " valign = " top " >

< asp:Image ID = " Image_Show " runat = " server " /></ td >

</ tr >

< tr >

< td style = " width: 181px " >

</ td >

< td style = " width: 7px " >

</ td >

< td style = " width: 18px " >

</ td >

</ tr >

< tr >

< td style = " width: 181px; height: 21px; " >

</ td >

< td style = " width: 7px; height: 21px; " >

</ td >

< td style = " width: 18px; height: 21px; " >

</ td >

</ tr >

</ table >

< asp:SqlDataSource ID = " SqlDataSource_SelectImage " runat = " server " ConnectionString = " <%$ ConnectionStrings:ImageSelect_ConnectionString %> "

SelectCommand = " SELECT PersonID, PersonName, PersonImageType FROM Person " ></ asp:SqlDataSource >

</ form >

</ body >

</ html >

ImageFileUpload.aspx.cs：

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 ImageFileUpload : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

}

protected void AddPerson(object sender, EventArgs e)

{

int intImageSize;

string strImageType;

Stream ImageStream;

intImageSize = PersonImage.PostedFile.ContentLength;

ImageStream = PersonImage.PostedFile.InputStream;

strImageType = PersonImage.PostedFile.ContentType;

Byte[] ImageContent = new Byte[intImageSize];

int intStatus;

intStatus = ImageStream.Read(ImageContent, 0, intImageSize);

//string ConnStr = System.Configuration.ConfigurationSettings.AppSettings["Lw_SqlConnectString"];

string ConnStr = "Data Source=127.0.0.1;Initial Catalog=Pfrmis_TZXY;User ID=sa";

SqlConnection myConnection=new SqlConnection(ConnStr);

SqlCommand myCommand=new SqlCommand("sp_person_isp", myConnection);

myCommand.CommandType = CommandType.StoredProcedure;

SqlParameter prmEmail=new SqlParameter("@PersonEmail", SqlDbType.VarChar, 255);

prmEmail.Value = txtPersonEmail.Text;

myCommand.Parameters.Add(prmEmail);

SqlParameter prmName=new SqlParameter("@PersonName", SqlDbType.VarChar, 255);

prmName.Value = txtPersonName.Text;

myCommand.Parameters.Add(prmName);

SqlParameter prmSex =new SqlParameter("@PersonSex", SqlDbType.Char, 1);

if (sexMale.Checked)

{

prmSex.Value = "M";

}

else

{

prmSex.Value = "F";

}

myCommand.Parameters.Add(prmSex);

SqlParameter prmPersonDOB= new SqlParameter("@PersonDOB", SqlDbType.DateTime);

prmPersonDOB.Value = txtPersonDob.Text;

myCommand.Parameters.Add(prmPersonDOB);

SqlParameter prmPersonImage =new SqlParameter("@PersonImage", SqlDbType.Image);

prmPersonImage.Value = ImageContent;

myCommand.Parameters.Add(prmPersonImage);

SqlParameter prmPersonImageType =new SqlParameter("@PersonImageType", SqlDbType.VarChar, 255);

prmPersonImageType.Value = strImageType;

myCommand.Parameters.Add(prmPersonImageType);

try

{

myConnection.Open();

myCommand.ExecuteNonQuery();

myConnection.Close();

Response.Write("添加成功！");

}

catch(SqlException SQLexc)

{

Response.Write("插入失败，错误如下： " + SQLexc.ToString());

}

protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)

{

// Session["id"] = "";

Label lbl1;

lbl1 = (Label)GridView1.SelectedRow.Cells[0].FindControl("Label1");

Label_Message.Text ="你选择的图片是："+lbl1.Text;

Session["id"] = lbl1.Text;

Image_Show.ImageUrl = "ImageShow.aspx";

}

ImageShow.aspx：(显示图片)

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

<! 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 runat = " server " >

< title > 无标题页 </ title >

</ head >

< body >

< form id = " form1 " runat = " server " >

< div >

</ div >

</ form >

</ body >

</ html >

ImageShow.aspx.cs:

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;

public partial class ImageShow : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

//连接数据库的第一种方法

SqlConnection myConnection = new SqlConnection(ConfigurationManager.AppSettings["Lw_SqlConnectString"]);

//连接数据库的第二种方法

//SqlConnection myConnection = new SqlConnection("Data Source=.;Initial Catalog=Tcis_shrl;User Id=sa;Password=;");

if (Session["id"] == null)

{

}

else

{

string sql = "Select PersonImage from Person Where PersonID=";

SqlCommand myCommand = new SqlCommand(sql + Session["id"].ToString().Trim(), myConnection);

try

{

myConnection.Open();

SqlDataReader myDataReader;

myDataReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection);

if (myDataReader.Read())

{

Response.Clear();

// Response.ContentType = "image/pjpeg";//可有可无

Response.BinaryWrite((byte[])myDataReader["PersonImage"]);

}

myConnection.Close();

}

catch (SqlException SQLexc)

{

Response.Write(SQLexc);

}

Response.End();

}

最后一个存储过程：
Drop Table Person

Create Table Person

(

PersonID Int Identity,

PersonEmail Varchar(255),

PersonName Varchar(255),

PersonSex Char(1),

PersonDOB DateTime,

PersonImage Image,

PersonImageType Varchar(255)

)

Drop Proc sp_person_isp

Create Proc sp_person_isp

@PersonEmail Varchar(255),

@PersonName Varchar(255),

@PersonSex Char(1),

@PersonDOB DateTime,

@PersonImage Image,

@PersonImageType Varchar(255)

Begin

Insert into Person

(PersonEmail, PersonName, PersonSex,

PersonDOB, PersonImage, PersonImageType)

Values

(@PersonEmail, @PersonName, @PersonSex,

@PersonDOB, @PersonImage, @PersonImageType)

End

转载于:https://www.cnblogs.com/cry/archive/2007/01/18/623973.html

weixin_30765505

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
Asp.net 2.0(C#)图片存储到数据库和从数据库读取显示

最近捣鼓了一下，效果就是这样：图1：图2：ImageFileUpload.aspx：<%@PageLanguage="C#"AutoEventWireup="true"CodeFile="ImageFileUpload.aspx.cs"Inherits="ImageFileUpload"%><!DOCTYPEhtmlPUBLIC"-//W3C//DTDXH...
复制链接

扫一扫