鉴于问的人较多，先贴出代码

Image2Access.ASPx

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

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

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

{

///

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();

}

#region Web 窗体设计器生成的代码

override protected void OnInit(EventArgs e)

{

//

// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。

//

InitializeComponent();

base.OnInit(e);

}

///

private void InitializeComponent()

{

this.Submit1.ServerClick += new System.EventHandler(this.Submit1_ServerClick);

this.Load += new System.EventHandler(this.Page_Load);

}

#endregion

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();

}

}

}

做人要厚道，请注明转自酷网动力(www.ASPCOOL.COM)。