asp.NET上传文件到指定文件夹,ACCESS数据库,SQL数据库代码

最新推荐文章于 2009-10-03 05:57:00 发布

疾风铸境

最新推荐文章于 2009-10-03 05:57:00 发布

阅读量2.7k

点赞数

分类专栏： ASP.NET开发文章标签：数据库 asp.net access sql string textbox

本文链接：https://blog.csdn.net/xqf222/article/details/879572

版权

ASP.NET开发专栏收录该内容

47 篇文章 0 订阅

订阅专栏

我修改了一天时间.终于找到门路了。呵呵
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;
  }
}
}