Skip to content Skip to sidebar Skip to footer
Página inicial / How to Upload a Blob File to Database in Php File Upload

How to Upload a Blob File to Database in Php File Upload

Postar um comentário

OverviewToday, we will come across how to upload files, whether it's a Word file, pdf, zip files etc., and save them in the Oracle database every bit well as call up those files and download those. This code is useful when y'all need to upload various documents in an arrangement, including process documents, news then on. Other users will have to download those files and meet the contents. To see the content of what yous have uploaded, you accept to save information technology in Binary format. Let'due south commencement:

uploaded

Stride i : Lets create a tabular array first Showtime, yous need to install the Oracle Database on your car and create databases in your system. The Oracle SQL Developer is a GUI to access those databases.

One time y'all are through with the installation and creation of the database, it is time to add together a connection.

Note:

Earlier installing Oracle, yous need to add together TNS names in tnsnames.ora in gild to communicate with your databases.

Become to your system bulldoze where you had installed the Oracle. This is my path:

path

Open tnsname.ora file and add together a TNS entry there.

code

At present, configure the connection in your Oracle SQL Developer.

SQL

Click on Connect. It will add together a connection successfully. We have continued to our database successfully .

database

Now, let's create a table.

table

Wait at the Data type in Oracle carefully. I made ID as chief key. Oracle doesn't identify the GUI. And then, you have to write a query for this .

The name I gave is Varchar2 with a length of 4000 Bytes (maximum).
Content type is again varchar2 which is again 4000 Bytes long (maximum).

Data is stored in BLOB. ( Remember in the previous article in SQL server we had been storing data in Binary Format). Here, in Oracle,  we will be saving Data in BLOB .

Once we accept created the tabular array, it'southward time to create id every bit autoincrement.

Simply blazon this command,

command

It will create a sequence, doc_id. Now, just run across by selecting the argument if your sequence has been created or not .

command

Step two : Open Visual Studio
Open Visual Studio File->New Website.

New Website

Select ASP.NET Empty Website and Give suitable name as DocumentSaveInBinary,

DocumentSaveInBinary

Now, allow's create FileUpload Control as,

code

  1. < asp:FileUpload ID = "FileUpload1" runat = "server" />
  2. < asp:Button ID = "btnUpload" runat = "server" Text = "Upload" OnClick = "Upload" CssClass = "btn-master" />

Now, create Gridview with Download Link button, then that nosotros can download respective documents or Files .

code

  1. < asp:GridView ID = "GridView1" runat = "server"
  3. AutoGenerateColumns = "false" CssClass = "table" >
  4. < Columns >
  5. < asp:BoundField DataField = "Name" HeaderText = "File Name" />
  6. < asp:TemplateField ItemStyle-HorizontalAlign = "Centre" >
  7. < ItemTemplate >
  8. < asp:LinkButton ID = "lnkDownload" runat = "server" Text = "Download" OnClick = "DownloadFile"
  9. CommandArgument = '<%# Eval("Id") %>' > </ asp:LinkButton >
  10. </ ItemTemplate >
  11. </ asp:TemplateField >
  12. </ Columns >
  13. </ asp:GridView >

Here you will see that inside Gridview used <asp:BoundField/> Showing HeaderText as FileName in gridview. In that <Itemtemplate></Itemtemplate> Within Itemtemplate you demand to bind Link button with ID="lnkDownload" OnClick="DownloadFile".

Then my final Document.aspx lawmaking is,

  1. < %@ Page Language = "C#" AutoEventWireup = "true" CodeFile = "DocumentUpload.aspx.cs" Inherits = "_Default"  % >
  3. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML i.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  4. < html xmlns = "http://www.w3.org/1999/xhtml" >
  5. < head id = "Head1" runat = "server" >
  6. < championship > </ title >
  7. < link rel = "Stylesheet" href = "Styles/bootstrap.min.css" style = "" />
  8. < link rel = "Stylesheet" href = "Styles/bootstrap.css" />
  9. </ caput >
  10. < body >
  11. < course id = "form1" runat = "server" >
  12. < div class = "container" >
  13. < asp:FileUpload ID = "FileUpload1" runat = "server" />
  14. < asp:Button ID = "btnUpload" runat = "server" Text = "Upload" OnClick = "Upload" CssClass = "btn-main" />
  15. < hour />
  16. < asp:GridView ID = "GridView1" runat = "server"
  18. AutoGenerateColumns = "fake" CssClass = "table" >
  19. < Columns >
  20. < asp:BoundField DataField = "Name" HeaderText = "File Name" />
  21. < asp:TemplateField ItemStyle-HorizontalAlign = "Center" >
  22. < ItemTemplate >
  23. < asp:LinkButton ID = "lnkDownload" runat = "server" Text = "Download" OnClick = "DownloadFile"
  24. CommandArgument = '<%# Eval("Id") %>' > </ asp:LinkButton >
  25. </ ItemTemplate >
  26. </ asp:TemplateField >
  27. </ Columns >
  28. </ asp:GridView >
  29. </ div >
  30. </ form >
  31. </ body >
  32. </ html >

Step 3 : Now let'south meet CS Lawmaking Part

Our File Upload Code is :

code

As you lot see in the above code,  we are saving our tabular array FileName,Contentype; hither the content types are word, pdf, image and so on and then we are saving the posted file in binary format past using Stream. File which you had uploaded in Fileupload Control and is converted in the binary file through BinaryReader .

Hither, I have added a connexion string in the code .

Now, while adding, you demand to insert the id. Encounter, what I had inserted:  sequencename.next val

When we were inserting in SQL, we were using "@" . Hither, in Oracle, we are using ":":

  1. string  constr = "User ID=axis_nsdl;Password=a$xis_4321;Information Source=TSTDPSEC" ;
  2. using  (OracleConnection con = new  OracleConnection(constr))
  3.              {
  4. string  query = "insert into tblFiles values (doc_id.nextval,:Name, :ContentType, :Data)" ;
  5. using  (OracleCommand cmd = new  OracleCommand(query))
  6.                  {
  7.                      cmd.Connection = con;
  9.                      cmd.Parameters.AddWithValue(":Name" , filename);
  10.                      cmd.Parameters.AddWithValue(":ContentType" , contentType);
  11.                      cmd.Parameters.AddWithValue(":Data" , bytes);
  12.                      con.Open();
  13.                      cmd.ExecuteNonQuery();
  14.                      con.Close();
  15.                  }
  16.              }
  17.          }
  18.      }
  • Similarly, we volition write the code for download, as we had created Onclick in gridview every bit Download File

    code

    Now, we Volition Demark the gridView :

    code

    So my Terminal CS Code is

    1. using  System;
    2. using  Organisation.Collections.Generic;
    3. using  System.Linq;
    4. using  System.Web;
    5. using  System.Information;
    6. using  Organisation.Data.SqlClient;
    7. using  System.IO;
    8. using  Organization.Web.UI.WebControls;
    9. using  Arrangement.Spider web;
    10. using  System.Configuration;
    11. using  System.Data.OracleClient;
    13. public  partial class  _Default : System.Spider web.UI.Page
    14. {
    18. private  OracleConnection con = new  OracleConnection( "User ID=axis_nsdl;Countersign=a$xis_4321;Data Source=TSTDPSEC" );
    19. protected void  Page_Load( object  sender, EventArgs east)
    20.     {
    21.         BindGrid();
    22.     }
    24. private void  BindGrid()
    25.     {
    27. string  constr = "User ID=axis_nsdl;Password=a$xis_4321;Data Source=TSTDPSEC" ;
    28. using  (OracleConnection con = new  OracleConnection(constr))
    29.         {
    30. using  (OracleCommand cmd = new  OracleCommand())
    31.             {
    32.                 cmd.CommandText ="select Id, Name from tblFiles" ;
    33.                 cmd.Connection = con;
    34.                 con.Open up();
    35.                 GridView1.DataSource = cmd.ExecuteReader();
    36.                 GridView1.DataBind();
    37.                 con.Close();
    38.             }
    39.         }
    40.     }
    41. protected void  Upload( object  sender, EventArgs e)
    42.     {
    43. string  filename = Path.GetFileName(FileUpload1.PostedFile.FileName);
    44. string  contentType = FileUpload1.PostedFile.ContentType;
    45. using  (Stream fs = FileUpload1.PostedFile.InputStream)
    46.         {
    47. using  (BinaryReader br = new  BinaryReader(fs))
    48.             {
    49. byte [] bytes = br.ReadBytes((Int32)fs.Length);
    50. string  constr = "User ID=axis_nsdl;Countersign=a$xis_4321;Data Source=TSTDPSEC" ;
    51. using  (OracleConnection con = new  OracleConnection(constr))
    52.                 {
    53. cord  query = "insert into tblFiles values (doc_id.nextval,:Name, :ContentType, :Data)" ;
    54. using  (OracleCommand cmd = new  OracleCommand(query))
    55.                     {
    56.                         cmd.Connectedness = con;
    58.                         cmd.Parameters.AddWithValue(":Name" , filename);
    59.                         cmd.Parameters.AddWithValue(":ContentType" , contentType);
    60.                         cmd.Parameters.AddWithValue(":Data" , bytes);
    61.                         con.Open();
    62.                         cmd.ExecuteNonQuery();
    63.                         con.Close();
    64.                     }
    65.                 }
    66.             }
    67.         }
    68.         Response.Redirect(Request.Url.AbsoluteUri);
    69.     }
    73. protected void  DownloadFile( object  sender, EventArgs e)
    74.     {
    75. int  id = int .Parse((sender as  LinkButton).CommandArgument);
    76. byte [] bytes;
    77. string  fileName, contentType;
    78. string  constr = "User ID=axis_nsdl;Password=a$xis_4321;Information Source=TSTDPSEC" ;
    79. using  (OracleConnection con = new  OracleConnection(constr))
    80.         {
    81. using  (OracleCommand cmd = new  OracleCommand())
    82.             {
    83.                 cmd.CommandText ="select Name, Data, ContentType from tblFiles where Id=:Id" ;
    84.                 cmd.Parameters.AddWithValue(":Id" , id);
    85.                 cmd.Connection = con;
    86.                 con.Open();
    87. using  (OracleDataReader sdr = cmd.ExecuteReader())
    88.                 {
    89.                     sdr.Read();
    91.                     bytes = (byte [])sdr[ "Data" ];
    92.                     contentType = sdr["ContentType" ].ToString();
    93.                     fileName = sdr["Proper name" ].ToString();
    94.                 }
    95.                 con.Close();
    96.             }
    97.         }
    98.         Response.Clear();
    99.         Response.Buffer =true ;
    100.         Response.Charset ="" ;
    101.         Response.Enshroud.SetCacheability(HttpCacheability.NoCache);
    102.         Response.ContentType = contentType;
    103.         Response.AppendHeader("Content-Disposition" , "attachment; filename="  + fileName);
    104.         Response.BinaryWrite(bytes);
    105.         Response.Flush();
    106.         Response.End();
    107.     }
    109. protected void  BtnSearch_Click( object  sender, System.EventArgs east)
    110.     {
    113.         con.Open();
    114.         OracleCommand cmd =new  OracleCommand( "Select * from Proper name where tblFiles like '"  + txtSearch.Text + "%'" , con);
    115.         OracleDataAdapter da =new  OracleDataAdapter(cmd);
    116.         DataSet ds =new  DataSet();
    117.         da.Make full(ds);
    118.         con.Close();
    119.         GridView1.DataSource = ds;
    120.         GridView1.DataBind();
    121.     }
    122. protected void  btnBack_Click( object  sender, System.EventArgs eastward)
    123.     {
    124.         Response.Redirect("alphabetize.html" );
    125.     }
    126. }
  • Just Run the Application Debug on Activity Events to see the FileUpload and its content.

    Application

    application

    Nosotros accept successfully uploaded the file. At present, let's download and encounter the information .

    data

    data

    We have successfully downloaded . Now, let'southward meet the Oracle tabular array part

    table part

    As you tin can see, the data is stored in BLOB format successfully.

johnswoperand1967.blogspot.com

Source: https://www.c-sharpcorner.com/article/upload-files-and-save-in-oracle-database-in-blob-format-in-asp-net/

Talvez você goste destas postagens

Postar um comentário for "How to Upload a Blob File to Database in Php File Upload"