Save Image To The Database Using FileUpload In ASP.NET

Nilesh Jadav

ASP.NET File UploadASP.NET FileUploadSave Image in Database

29 Comments

Join the conversation! Your thoughts help the community grow.

Gangadhar Jagtap5y ago
Getting below error after click on upload button Could not find a part of the path 'C:\Users\hp\Desktop\WebApp\WebApp\Upload\IMG-20200727-WA0003[2].jpg'
Rahul Patil6y ago
@Nilesh Jadav Image uploading successfully but how to display image??
- Nilesh Jadav6y ago
  Where to display ? I mean you can find your image in the project folder, access it from there.Or else bind your image with some control.
GUNJAN PARMAR7y ago
Getting this error while inserting image System.Data.SqlClient.SqlException: 'Operand type clash: nvarchar is incompatible with image'
- Nilesh Jadav7y ago
  Try with varchar
Farahin Rijal8y ago
Why i got error "Could not find a part of the path 'C:\WebSite9\Upload\1.png'" { string str = FileUpload1.FileName;FileUpload1.PostedFile.SaveAs(Server.MapPath("~/Upload/" + str)); string Image = "~/Upload/" + str.ToString(); string name = TextBox1.Text; please help me fix it. i got same problem as my previous project too.
Steve Boniface9y ago
Thank you for sharing. I wish I could get it to work, but I'm seeing an error: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)I've set everything up according to the instructions above. Not certain why this error is being encountered. Is there a critical piece you're presupposing that I may not have known about? Thank you
- Inderjit Kumar8y ago
  Check your connection string.
Rashid khan9y ago
Sir plzzz upload the code for how to show the uploaded image in gridview
- Nilesh Jadav9y ago
  Hi there ! This is my another tutorial - that exactly shows the upload image in grid, just the difference is I had made that in windows. It is quite similar process - Check it out here : www.c-sharpcorner.com/UploadFile/009464/insert-images-into-datagridview-in-windows-application-using/
Arul R11y ago
Good one !!!
Santhakumar Munuswamy11y ago
Good one
- Nilesh Jadav11y ago
  Thank you Santhakumar Munuswamy
Sibeesh Venu11y ago
Thanks for sharing
- Nilesh Jadav11y ago
  Thank you Sibeesh Venu
Mukesh Kumar11y ago
Great Job Sir
- Nilesh Jadav11y ago
  Thank you Mukesh Kumar
Ankit Bansal11y ago
nice..thanks for sharing
- Nilesh Jadav11y ago
  THANK YOU Ankit Bansal
Harshad Pansuriya11y ago
Nice one
- Nilesh Jadav11y ago
  Thank you Harshad Pansuriya
Rajeesh Menoth11y ago
Nice One..!!!
- Nilesh Jadav11y ago
  Thank you Rajeesh Menoth
Ravi Patel11y ago
nice work sir
- Nilesh Jadav11y ago
  Thank you Ravi Patel
Muhammad Aqib Shehzad11y ago
nice dear
- Nilesh Jadav11y ago
  Thank you Aqib Shehzad
Rakesh11y ago
Good one
- Nilesh Jadav11y ago
  Thank you Rakesh Chavda

We will save the name and path of the image to the database.

Initial chamber

Step 1: Open Visual Studio 2010 and create an empty website. Give it a suitable name: FileUpload_demo.

Step 2: In Solution Explorer you will get your empty website. Add a web form and SQL Database like the following:

For Web Form:

FileUpload_demo (Your Empty Website) - Right Click, Add New Item, then click Web Form. Name it Fileupload_demo.aspx.

Go back to your website in Solution Explorer and Add New Folder and Give name as - New Folder, then Upload.

folder

For SQL Server Database:

FileUpload_demo (Your Empty Website) - Right Click and Add New Item, then click SQL Server Database. Add Database inside the App_Data_folder.

Database chamber

Step 3: Go to your Database [Database.mdf], we will create a table - tbl_Data. Also, go to the database.mdf - Table and add new table, design your table like this:

Table - tbl_data ([Don’t forget to make ID, then Identity Specification as Yes).

table

Design chamber

Step 4: Open Fileupload_demo.aspx file to create our design, we will drag an HTML table, a FileUpload control, button, label and a textbox.

Fileupload_demo.aspx

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
<style type="text/css">
.style1
{
width: 283px;
}
.style2
{
width: 247px;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<div>
<table style="width:100%;">
<tr>
<td class="style1">
Image Name:</td>
<td class="style2">
<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
</td>
<td>
</td>
</tr>
<tr>
<td class="style1">
Upload Your Image:</td>
<td class="style2">
<asp:FileUpload ID="FileUpload1" runat="server" />
</td>
<td>
<asp:Label ID="Label1" runat="server"></asp:Label>
</td>
</tr>
<tr>
<td class="style1">
</td>
<td class="style2">
<asp:Button ID="Button1" runat="server" onclick="Button1_Click" Text="Upload" />
</td>
<td>
</td>
</tr>
</table>
</div>
</form>
</body>
</html>

Your design looks like the following image:

Design

Code chamber

Step 5: Open Fileupload_demo.aspx.cs file to write code for saving the image to database.

Fileupload_demo.aspx.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.IO;
using System.Data;
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
if (FileUpload1.HasFile)
{
string str = FileUpload1.FileName;
FileUpload1.PostedFile.SaveAs(Server.MapPath("~/Upload/" + str));
string Image = "~/Upload/" + str.ToString();
string name = TextBox1.Text;
SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True");
SqlCommand cmd = new SqlCommand("insert into tbl_data values(@name,@Image)", con);
cmd.Parameters.AddWithValue("@name", name);
cmd.Parameters.AddWithValue("Image", Image);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
Label1.Text = "Image Uploaded";
Label1.ForeColor = System.Drawing.Color.ForestGreen;
}
else
{
Label1.Text = "Please Upload your Image";
Label1.ForeColor = System.Drawing.Color.Red;
}
}
}

Output chamber

upload image

Hope you liked it. Have a good day. Thank you for reading.