Save Images And Files In Database

In this blog, we will learn how to save the files in the database table. We will make a Web Application. It is a secure way to save the data files/images in the database in the table.

Let’s start.

Database part Work

1. First, we create a table in SQL database.
   
   Eg,
   
   1. CREATE TABLE [dbo].[tbdata](
   2. [Blob] [varbinary](max) NOT NULL,
   3. [Name] [nvarchar](256) NULL,
   4. [Contenttype] [nvarchar](256) NULL
   5. ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

Visual Studio

1. Open Visual Studio, select File >New > Website
   
   
2. Name it, as you want. My Application’s name is SampleWeb.
   
   
   
   
3. First of all, open Solution Explorer and right click on ( Website Name) > Add > Add New Item > select Web Form:
   
   
   
   
4. Add the file uploader, label and button in Default.aspx page:
   
   Eg,
   1. <asp:FileUpload ID="FU1" runat="server" /> <br /> <br />
   2. <asp:LinkButton ID="lb1" runat="server" Text="Submit" OnClick="lb1_Click" /> <br /><br />
   3. <asp:Label id="Label1" runat="server" />
   
   
   
5. Add the code on Default.aspx.cs page:
   
   Eg,
   
   1. protected void lb1_Click(object sender, EventArgs e) {
   2. if (FU1.HasFile) {
   3. try {
   4. string content_type = FU1.PostedFile.ContentType;
   5. string filename = FU1.PostedFile.FileName.ToLower();
   6. SqlConnection conn;
   7. SqlCommand cmd = new SqlCommand();
   8. conn = new SqlConnection("Data Source=DESKTOP-C4AN6J2\\SQLEXPRESS;Initial Catalog=test; Integrated Security=true;");
   9. conn.Open();
   10. BinaryReader br = new BinaryReader(FU1.PostedFile.InputStream);
   11. Byte[] bytes = br.ReadBytes((Int32) FU1.PostedFile.InputStream.Length);
   12. cmd.CommandText = "Insert into tbdata (Blob,Name,Contenttype)values( @bytes,@Name,@Contenttype)";
   13. cmd.Connection = conn;
   14. cmd.Parameters.AddWithValue("@bytes", bytes);
   15. cmd.Parameters.AddWithValue("@Name", filename);
   16. cmd.Parameters.AddWithValue("@Contenttype", content_type);
   17. cmd.ExecuteNonQuery();
   18. cmd.Dispose();
   19. cmd.Connection.Close();
   20. Label1.Text = "Uploaded Sucessfully";
   21. } catch {
   22. Label1.Text = "Not Uploaded Sucessfully";
   23. }
   24. } else Label1.Text = "No Upload";
   25. }