ASP.NET上傳文件代碼！！怎麽寫比如說：上傳圖片

我修改了壹天時間.終於找到門路了。呵呵

ACCESS中存放文件內容的字段類型為:OLE對象

SQL中存放文件內容的字段類型為:image

此代碼為上傳文件代碼.梢後整理發布下載文件代碼

代碼設計實現功能:asp.NET上傳文件到指定文件夾,ACCESS數據庫,SQL數據庫代碼

已經測試文件格式 .TXT,JPG..MDB.GIF

*/

using System;

using System.Collections;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Web;

using System.Web.SessionState;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.HtmlControls;

using System.IO;

using System.Data.OleDb;

using System.Data.SqlClient;

namespace WebApplication1.ManageFile

{

/// <summary>

/// ManageUploadFile 的摘要說明。

/// </summary>

public class ManageUploadFile : System.Web.UI.Page

{

protected System.Web.UI.WebControls.DropDownList DropDownList1;

protected System.Web.UI.WebControls.Button Button2;

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

protected System.Web.UI.WebControls.TextBox TextBox1;

protected System.Web.UI.WebControls.CheckBox CheckBox1;

protected System.Web.UI.WebControls.Button Button4;

protected System.Web.UI.WebControls.Button Button5;

protected System.Web.UI.WebControls.Button Button3;

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

{

// 在此處放置用戶代碼以初始化頁面

}

#region Web 窗體設計器生成的代碼

override protected void OnInit(EventArgs e)

{

//

// CODEGEN: 該調用是 ASP.NET Web 窗體設計器所必需的。

//

InitializeComponent();

base.OnInit(e);

}

/// <summary>

/// 設計器支持所需的方法 - 不要使用代碼編輯器修改

/// 此方法的內容。

/// </summary>

private void InitializeComponent()

{

this.Button2.Click += new System.EventHandler(this.Button2_Click);

this.Button3.Click += new System.EventHandler(this.Button3_Click);

this.Button4.Click += new System.EventHandler(this.Button4_Click);

this.Button5.Click += new System.EventHandler(this.Button5_Click);

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

}

#endregion

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

{

if(file1.PostedFile.FileName!="")

{

if(CheckBox1.Checked)

{

}

else

{

//上傳文件到數據庫中

string sUploadFileName=file1.PostedFile.FileName;

string strUploadFile=Server.MapPath(".")+"\\"+DropDownList1.SelectedItem.Text.ToString()+"\\";

sUploadFileName=sUploadFileName.Substring(sUploadFileName.LastIndexOf("\\")).Replace("\\","");

string sUploadFilePath=strUploadFile+sUploadFileName;

int sUploadFileLength=file1.PostedFile.ContentLength;

string sUploadFileType=file1.PostedFile.ContentType.ToString();

//AppDomain.CurrentDomain.BaseDirectory.ToString()站點跟目錄

//file1.PostedFile.SaveAs(sUploadFilePath);

System.Byte[] Docbuffer = new byte[sUploadFileLength];

Stream objStream = file1.PostedFile.InputStream;

objStream.Read(Docbuffer,0,sUploadFileLength);

string DbName=Server.MapPath(".")+"\\DataBase\\HtmlFile.mdb";

string ConnectionString ="PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source=" + DbName;

string AccessSqlString="Insert Into UploadFiles(UploadFileName,UploadFileType,UploadFilePath,UploadFileLength,UploadFileContent) Values('" +sUploadFileName+ "','"+sUploadFileType+ "','" +sUploadFilePath+ "',"+sUploadFileLength+ ","+ Docbuffer + ")";

OleDbConnection myConnection =new OleDbConnection(ConnectionString);

myConnection.Open();

OleDbCommand myCommand =new OleDbCommand(AccessSqlString,myConnection);

myCommand.ExecuteNonQuery();

myConnection.Close();

string strUpfileResult="上傳文件到數據庫成功\r\n";

strUpfileResult=strUpfileResult+"文件名"+sUploadFileName+"\r\n";

strUpfileResult=strUpfileResult+"文件大小"+sUploadFileLength+"\r\n";

strUpfileResult=strUpfileResult+"文件格式"+sUploadFileType+"\r\n";

TextBox1.Text=strUpfileResult;

}

}

}

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

{

string strCurrentDirectory=Server.MapPath(".");

DirectoryInfo di=new DirectoryInfo(strCurrentDirectory);

int dtotal=0;

if(DropDownList1.Items.Count!=0)

{

for(int j=DropDownList1.Items.Count-1;j>=0;j--)

{

DropDownList1.Items.RemoveAt(j);

}

}

for(int i=0;i<di.GetDirectories().Length;i++)

{

//subd=subd+"<br>"+di.GetDirectories().GetValue(i);

dtotal=dtotal+1;

DropDownList1.Items.Add(di.GetDirectories().GetValue(i).ToString());

}

}

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

{

string sUploadFileName=file1.PostedFile.FileName;

string strUploadFile=Server.MapPath(".")+"\\"+DropDownList1.SelectedItem.Text.ToString()+"\\";

sUploadFileName=sUploadFileName.Substring(sUploadFileName.LastIndexOf("\\")).Replace("\\","");

string sPath=strUploadFile+sUploadFileName;

//AppDomain.CurrentDomain.BaseDirectory.ToString()站點跟目錄

file1.PostedFile.SaveAs(sPath);

string sUploadFileLength=file1.PostedFile.ContentLength.ToString();

string sUploadFileType=file1.PostedFile.ContentType.ToString();

string strUpfileResult="上傳文件成功\r\n";

strUpfileResult=strUpfileResult+"文件名"+sUploadFileName+"\r\n";

strUpfileResult=strUpfileResult+"文件大小"+sUploadFileLength+"\r\n";

strUpfileResult=strUpfileResult+"文件格式"+sUploadFileType+"\r\n";

TextBox1.Text=strUpfileResult;

}

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

{

//上傳文件到數據庫中

string sUploadFileName=file1.PostedFile.FileName;

string strUploadFile=Server.MapPath(".")+"\\"+DropDownList1.SelectedItem.Text.ToString()+"\\";

sUploadFileName=sUploadFileName.Substring(sUploadFileName.LastIndexOf("\\")).Replace("\\","");

string sUploadFilePath=strUploadFile+sUploadFileName;

int sUploadFileLength=file1.PostedFile.ContentLength;

string sUploadFileType=file1.PostedFile.ContentType.ToString();

//AppDomain.CurrentDomain.BaseDirectory.ToString()站點跟目錄

//file1.PostedFile.SaveAs(sUploadFilePath);

System.Byte[] Docbuffer = new byte[sUploadFileLength];

Stream objStream = file1.PostedFile.InputStream;

objStream.Read(Docbuffer,0,sUploadFileLength);

string DbName=Server.MapPath(".")+"\\DataBase\\HtmlFile.mdb";

string ConnectionString ="PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source=" + DbName;

//string AccessSqlString="Insert Into UploadFiles(UploadFileName,UploadFileType,UploadFilePath,UploadFileLength) Values('" +sUploadFileName+ "','"+sUploadFileType+ "','" +sUploadFilePath+ "',"+sUploadFileLength+")";

string AccessSqlString="Insert Into UploadFiles(UploadFileName,UploadFileType,UploadFilePath,UploadFileLength,UploadFileContent) Values('" +sUploadFileName+ "','"+sUploadFileType+ "','" +sUploadFilePath+ "',"+sUploadFileLength+ ",'"+ Docbuffer + "')";

OleDbConnection myConnection =new OleDbConnection(ConnectionString);

myConnection.Open();

OleDbCommand myCommand =new OleDbCommand(AccessSqlString,myConnection);

myCommand.ExecuteNonQuery();

myConnection.Close();

string strUpfileResult="上傳文件到數據庫成功\r\n";

strUpfileResult=strUpfileResult+"上傳文件名"+sUploadFileName+"\r\n";

strUpfileResult=strUpfileResult+"上傳文件大小"+sUploadFileLength+"\r\n";

strUpfileResult=strUpfileResult+"上傳文件路徑"+sUploadFilePath+"\r\n";

strUpfileResult=strUpfileResult+"上傳文件格式"+sUploadFileType+"\r\n";

TextBox1.Text=strUpfileResult;

}

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

{

//上傳文件到數據庫中

string sUploadFileName=file1.PostedFile.FileName;

string strUploadFile=Server.MapPath(".")+"\\"+DropDownList1.SelectedItem.Text.ToString()+"\\";

sUploadFileName=sUploadFileName.Substring(sUploadFileName.LastIndexOf("\\")).Replace("\\","");

string sUploadFilePath=strUploadFile+sUploadFileName;

int sUploadFileLength=file1.PostedFile.ContentLength;

string sUploadFileType=file1.PostedFile.ContentType.ToString();

//AppDomain.CurrentDomain.BaseDirectory.ToString()站點跟目錄

//file1.PostedFile.SaveAs(sUploadFilePath);

System.Byte[] Docbuffer = new byte[sUploadFileLength];

Stream objStream = file1.PostedFile.InputStream;

objStream.Read(Docbuffer,0,sUploadFileLength);

//string strCon ="Initial Catalog=Northwind;Data Source=localhost;Integrated Security=SSPI;";

//UID=sa,PWD=hNXQF222,Server=127.0.0.1,Database=Aspnet";

/*

SqlCommand myCommand = new SqlCommand(myExecuteQuery, myConnection);

myCommand.Connection.Open();

myCommand.ExecuteNonQuery();

myConnection.Close();

*/

string strConn ="DATABASE=Aspuser;SERVER=localhost;UID=sa;PWD=hNXQF222;";

SqlConnection Conn = new SqlConnection(strConn);

Conn.Open();

string mySqlCommand = "INSERT INTO UploadFiles (UploadFileName,UploadFileType,UploadFilePath,UploadFileLength,UploadFileContent) VALUES (@UploadFileName,@UploadFileType,@UploadFilePath,@UploadFileLength,@UploadFileContent)";

SqlCommand CmdObj = new SqlCommand(mySqlCommand, Conn);

CmdObj.Parameters.Add("@UploadFileName",SqlDbType.VarChar,50).Value = sUploadFileName;

CmdObj.Parameters.Add("@UploadFileType",SqlDbType.VarChar,50).Value = sUploadFileType;

CmdObj.Parameters.Add("@UploadFilePath",SqlDbType.VarChar,200).Value = sUploadFilePath;

CmdObj.Parameters.Add("@UploadFileLength",SqlDbType.BigInt,8).Value = sUploadFileLength;

CmdObj.Parameters.Add("@UploadFileContent",SqlDbType.Image).Value = Docbuffer;

CmdObj.ExecuteNonQuery();

Conn.Close();

string strUpfileResult="上傳文件到數據庫成功\r\n";

strUpfileResult=strUpfileResult+"上傳文件名"+sUploadFileName+"\r\n";

strUpfileResult=strUpfileResult+"上傳文件大小"+sUploadFileLength+"\r\n";

strUpfileResult=strUpfileResult+"上傳文件路徑"+sUploadFilePath+"\r\n";

strUpfileResult=strUpfileResult+"上傳文件格式"+sUploadFileType+"\r\n";

TextBox1.Text=strUpfileResult;

}

}

}