图片上传到数据库并显示（C#+Access）_Asp.NET数据库操作
日期：2009-08-26 浏览次数：20428 次
//上传文件：upload.ASPx
<%@ Page Language="C#" %>
<%@ import Namespace="System.Data" %>
<%@ import Namespace="System.Data.OleDb" %>
<%@ import Namespace="System.IO" %>
<script runat="server">
public void AddPerson(object sender, EventArgs e)
{
Int64 intImageSize;
string strImageType;
Stream ImageStream ;
intImageSize = PersonImage.PostedFile.ContentLength;
strImageType = PersonImage.PostedFile.ContentType;
ImageStream = PersonImage.PostedFile.InputStream;
Byte[] ImageContent = new Byte[intImageSize];
int intStatus= ImageStream.Read(ImageContent,0,PersonImage.PostedFile.ContentLength);
OleDbConnection MyConnection = new OleDbConnection( "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("ps.mdb"));
OleDbCommand MyCommand = new OleDbCommand("INSERT INTO manhua(img,biaoti,laiyuan,author,keyword,content) values(@img,@biaoti,@laiyuan,@author,@keyword,@content)", MyConnection);
MyCommand.Parameters.Add("@img",ImageContent);
MyCommand.Parameters.Add("@biaoti",txtname.Text);
MyCommand.Parameters.Add("@laiyuan",TextBox1.Text);
MyCommand.Parameters.Add("@author",TextBox2.Text);
MyCommand.Parameters.Add("@keyword",TextBox3.Text);
MyCommand.Parameters.Add("@content",TextBox4.Text);
try
{
MyConnection.Open();
MyCommand.ExecuteNonQuery();
MyConnection.Close();
//Response.Write("<font color="red">new person successfully added!</font>");
}
catch(OleDbException ex)
{
Response.Write("Insert Failed.Error Details are:" + ex.ToString());
}
txtname.Text="";
}
</script>
<HTML>
<head>
<title>Upload image to DB!</title>
</head>
<body style="FONT: 10pt verdana">
<form enctype="multipart/form-data" runat="server">
<table align="center">
<tbody>
<tr>
<td>
<font size="2">标 题:</font>
<ASP:Textbox id="txtname" runat="server"></ASP:Textbox>
</td>
</tr>
<tr>
<td>
<font size="2">来 源:</font>
<ASP:TextBox id="TextBox1" runat="server"></ASP:TextBox>
</td>
</tr>
<tr>
<td>
<font size="2">作 者:</font>
<ASP:TextBox id="TextBox2" runat="server"></ASP:TextBox>
</td>
</tr>
<tr>
<td>
<font size="2">关键字:</font>
<ASP:TextBox id="TextBox3" runat="server">
<%@ Page Language="C#" %>
<%@ import Namespace="System.Data" %>
<%@ import Namespace="System.Data.OleDb" %>
<%@ import Namespace="System.IO" %>
<script runat="server">
public void AddPerson(object sender, EventArgs e)
{
Int64 intImageSize;
string strImageType;
Stream ImageStream ;
intImageSize = PersonImage.PostedFile.ContentLength;
strImageType = PersonImage.PostedFile.ContentType;
ImageStream = PersonImage.PostedFile.InputStream;
Byte[] ImageContent = new Byte[intImageSize];
int intStatus= ImageStream.Read(ImageContent,0,PersonImage.PostedFile.ContentLength);
OleDbConnection MyConnection = new OleDbConnection( "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("ps.mdb"));
OleDbCommand MyCommand = new OleDbCommand("INSERT INTO manhua(img,biaoti,laiyuan,author,keyword,content) values(@img,@biaoti,@laiyuan,@author,@keyword,@content)", MyConnection);
MyCommand.Parameters.Add("@img",ImageContent);
MyCommand.Parameters.Add("@biaoti",txtname.Text);
MyCommand.Parameters.Add("@laiyuan",TextBox1.Text);
MyCommand.Parameters.Add("@author",TextBox2.Text);
MyCommand.Parameters.Add("@keyword",TextBox3.Text);
MyCommand.Parameters.Add("@content",TextBox4.Text);
try
{
MyConnection.Open();
MyCommand.ExecuteNonQuery();
MyConnection.Close();
//Response.Write("<font color="red">new person successfully added!</font>");
}
catch(OleDbException ex)
{
Response.Write("Insert Failed.Error Details are:" + ex.ToString());
}
txtname.Text="";
}
</script>
<HTML>
<head>
<title>Upload image to DB!</title>
</head>
<body style="FONT: 10pt verdana">
<form enctype="multipart/form-data" runat="server">
<table align="center">
<tbody>
<tr>
<td>
<font size="2">标 题:</font>
<ASP:Textbox id="txtname" runat="server"></ASP:Textbox>
</td>
</tr>
<tr>
<td>
<font size="2">来 源:</font>
<ASP:TextBox id="TextBox1" runat="server"></ASP:TextBox>
</td>
</tr>
<tr>
<td>
<font size="2">作 者:</font>
<ASP:TextBox id="TextBox2" runat="server"></ASP:TextBox>
</td>
</tr>
<tr>
<td>
<font size="2">关键字:</font>
<ASP:TextBox id="TextBox3" runat="server">
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
