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

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

weixin_30765505

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

阅读量178

点赞数

CC 4.0 BY-SA版权

文章标签：数据库 ui xhtml

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

本文介绍了一个基于 ASP.NET 的图片上传与显示系统实现，包括前端页面设计、后端处理逻辑及数据库交互过程。该系统能够接收用户上传的图片，并将其存储到数据库中，同时展示已上传的图片。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

最近捣鼓了一下，效果就是这样：
图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">

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

</head>

<body>

<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>

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

</td>

</td>

</tr>

<tr>

<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">

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

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

</EditItemTemplate>

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

</ItemTemplate>

</asp:TemplateField>

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

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

<asp:CommandField ShowSelectButton="True" >

</asp:CommandField>

</Columns>

</asp:GridView>

</td>

</td>

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

</tr>

<tr>

</td>

</td>

</td>

</tr>

<tr>

</td>

</td>

</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">

</head>

<body>

<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