将文字内容和图片插入到 Access 数据库

最新推荐文章于 2021-07-02 02:32:44 发布

ITZYF

最新推荐文章于 2021-07-02 02:32:44 发布

阅读量688

点赞数

分类专栏： C# 文章标签： access asp image server string 数据库

C# 专栏收录该内容

36 篇文章

订阅专栏

本文介绍了一种将文件上传到Access数据库的方法，并提供了完整的Web应用程序示例代码。该程序使用ASP.NET和C#实现，展示了如何通过用户界面接收文件并将其存储到数据库中。

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

Image2Access.aspx

<%@ Page language="c#" Debug="true" Codebehind="Image2Access.aspx.cs"

AutoEventWireup="false" Inherits="eMeng.Exam.Image2Access" %>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >

<HTML>

<HEAD>

<title>上传文件到 Access 数据库</title>

</HEAD>

<h3 align="center">上传文件到 Access 数据库</h3>

<asp:DataGrid ID="DG_Persons" AutoGenerateColumns="False" Width="99%" HeaderStyle-BackColor="#ff0000"

HeaderStyle-Font-Bold="True" HeaderStyle-ForeColor="#ffffff" ItemStyle-BackColor="Beige" BorderColor="#000000"

Runat="server" HeaderStyle-HorizontalAlign="Center">

<asp:TemplateColumn HeaderText="姓名">

<asp:Label Runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "PersonName") %>' ID="Label1"/>

</ItemTemplate>

</asp:TemplateColumn>

<asp:TemplateColumn HeaderText="电子邮件">

<asp:Label Runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "PersonEmail") %>' ID="Label2"/>

</ItemTemplate>

</asp:TemplateColumn>

<asp:TemplateColumn HeaderText="性别">

<asp:Label Runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "PersonSex") %>' ID="Label3"/>

</ItemTemplate>

</asp:TemplateColumn>

<asp:TemplateColumn HeaderText="照片">

<asp:Image Runat=server ID="Image1"

ImageUrl='<%# FormatURL(DataBinder.Eval(Container.DataItem, "PersonID")) %>' />

</ItemTemplate>

</asp:TemplateColumn>

</Columns>

</asp:DataGrid>

<P>

<br>

</P>

</form>

</body>

</HTML>

Image2Access.aspx.cs

using System;

using System.Collections;

using System.ComponentModel;

using System.Data;

using System.Data.OleDb;

using System.Drawing;

using System.Web;

using System.IO;

using System.Web.SessionState;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.HtmlControls;

namespace eMeng.Exam

{

/// <summary>

/// Image2Access 的摘要说明。

/// </summary>

public class Image2Access : System.Web.UI.Page

{

protected System.Web.UI.HtmlControls.HtmlInputText MyFileName;

protected System.Web.UI.HtmlControls.HtmlInputFile MyFile;

protected System.Web.UI.HtmlControls.HtmlInputButton Submit1;

protected System.Web.UI.WebControls.DataGrid DG_Persons;

private void Page_Load(object sender, System.EventArgs e)

{

// 在此处放置用户代码以初始化页面

BindGrid();

}

private void BindGrid()

{

string strCnn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="

+ Server.MapPath("Image2Access.mdb");

OleDbConnection myConnection = new OleDbConnection(strCnn);

OleDbCommand myCommand = new OleDbCommand("SELECT * FROM Person", myConnection);

myCommand.CommandType = CommandType.Text;

try

{

myConnection.Open();

DG_Persons.DataSource = myCommand.ExecuteReader(CommandBehavior.CloseConnection);

DG_Persons.DataBind();

}

catch(OleDbException SQLexc)

{

Response.Write("提取数据时出现错误：" + SQLexc.ToString());

}

protected string FormatURL(object strArgument)

{

return "ReadImage.aspx?id=" + strArgument.ToString();

}

Web 窗体设计器生成的代码

private void Submit1_ServerClick(object sender, System.EventArgs e)

{

//得到提交的文件

Stream fileDataStream = MyFile.PostedFile.InputStream;

//得到文件大小

int fileLength = MyFile.PostedFile.ContentLength;

//创建数组

byte[] fileData = new byte[fileLength];

//把文件流填充到数组

fileDataStream.Read(fileData,0,fileLength);

//得到文件名字

string fileTitle = MyFileName.Value;

//得到文件类型

string fileType = MyFile.PostedFile.ContentType;

//构建数据库连接，SQL语句，创建参数

string strCnn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("Image2Access.mdb");

OleDbConnection myConnection = new OleDbConnection(strCnn);

OleDbCommand command = new OleDbCommand ("INSERT INTO Person (PersonName,PersonEmail,PersonSex,PersonImageType,PersonImage)" +

"VALUES (@PersonName,@PersonEmail,@PersonSex,@PersonImageType,@PersonImage)", myConnection);

System.Data.OleDb.OleDbParameter paramPersonName = new OleDbParameter("@PersonName", System.Data.OleDb.OleDbType.VarChar,50);

paramPersonName.Value = fileTitle;

command.Parameters.Add(paramPersonName);

System.Data.OleDb.OleDbParameter paramPersonEmail = new OleDbParameter("@PersonEmail", System.Data.OleDb.OleDbType.VarChar,50);

paramPersonEmail.Value = "mengxianhui@dotnet.aspx.cc";

command.Parameters.Add(paramPersonEmail);

System.Data.OleDb.OleDbParameter paramPersonSex = new OleDbParameter("@paramPersonSex", System.Data.OleDb.OleDbType.VarChar,50);

paramPersonSex.Value = "男";

command.Parameters.Add(paramPersonSex);

System.Data.OleDb.OleDbParameter paramPersonImageType = new OleDbParameter("@PersonImageType", System.Data.OleDb.OleDbType.VarChar,50);

paramPersonImageType.Value = fileType;

command.Parameters.Add(paramPersonImageType);

System.Data.OleDb.OleDbParameter paramPersonImage = new OleDbParameter("@PersonImage", System.Data.OleDb.OleDbType.Binary);

paramPersonImage.Value = fileData;

command.Parameters.Add(paramPersonImage);

//打开连接，执行查询

myConnection.Open();

command.ExecuteNonQuery();

myConnection.Close();

}