Asp. NET upload files to a specified folder, Access database, SQL database code

access|asp.net| Upload | data | database

/*

I modified the day. Finally found the way. Oh
The type of field in Access that holds the contents of the file is: OLE Object
The type of field in SQL that holds the contents of the file is: image
This code is for uploading file code. Post-Finishing release download file code

Code Design Implementation function: ASP. NET upload files to a specified folder, Access database, SQL database code

The file format has been tested. 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>
Summary description of the 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)
{
Place user code here to initialize page
}

   #region The code generated by the Web Forms Designer
  override protected void OnInit (EventArgs e)
  {
   //
   //codegen: This call is required for the ASP.net Web forms Designer.
   //
   initializecomponent ();
   base. OnInit (e);
  }
  
  ///<summary>
  ///Designer supports the desired method-do not use the Code Editor to modify
  /// The contents of this method.
  ///</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
{
Uploading files to the database
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 () Site and directory
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= "Upload file to database success \ r \ n";
strupfileresult=strupfileresult+ "filename" +suploadfilename+ "\ r \ n";
strupfileresult=strupfileresult+ "File size" +suploadfilelength+ "\ r \ n";
strupfileresult=strupfileresult+ "file format" +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 () Site and directory
File1. Postedfile.saveas (spath);
String Suploadfilelength=file1. PostedFile.ContentLength.ToString ();
String Suploadfiletype=file1. PostedFile.ContentType.ToString ();

String strupfileresult= "Upload file successfully \ r \ n";
strupfileresult=strupfileresult+ "filename" +suploadfilename+ "\ r \ n";
strupfileresult=strupfileresult+ "File size" +suploadfilelength+ "\ r \ n";
strupfileresult=strupfileresult+ "file format" +suploadfiletype+ "\ r \ n";

Textbox1.text=strupfileresult;
}

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

Uploading files to the database
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 () Site and directory
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= "Upload file to database success \ r \ n";
strupfileresult=strupfileresult+ "Upload filename" +suploadfilename+ "\ r \ n";
strupfileresult=strupfileresult+ "Upload file size" +suploadfilelength+ "\ r \ n";
strupfileresult=strupfileresult+ "Upload file path" +suploadfilepath+ "\ r \ n";
strupfileresult=strupfileresult+ "Upload file format" +suploadfiletype+ "\ r \ n";
Textbox1.text=strupfileresult;

}

private void Button5_click (object sender, System.EventArgs e)
{

Uploading files to the database
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 () Site and directory
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= "Upload file to database success \ r \ n";
strupfileresult=strupfileresult+ "Upload filename" +suploadfilename+ "\ r \ n";
strupfileresult=strupfileresult+ "Upload file size" +suploadfilelength+ "\ r \ n";
strupfileresult=strupfileresult+ "Upload file path" +suploadfilepath+ "\ r \ n";
strupfileresult=strupfileresult+ "Upload file format" +suploadfiletype+ "\ r \ n";
Textbox1.text=strupfileresult;
}
}
}