Save Images into Sql Server Database Table using asp.net FileUpload Control-..:: Programmer Kingdom ::..

This article will explain how one can insert or save images into a sql server database table using asp.net FileUpload control. You may ask why we will save or store images into sql server database table instead of a server folder? The answer is its easy to use, easy to manage, easy to backup as well as easy programming. But one thing you have to keep in mind that you need to extend the size of your database rather than your regular size. Always deleting images from server folder is a hectic job where security will play a great role but if you store images into sql server database you can remove images or related images by issuing a simple delete sql command.

Save Images into Sql Server Database Table using asp.net FileUpload Control

google_ad_client = "pub-7628238925744083"; google_ad_host = "pub-1556223355139109"; google_ad_host_channel="00000+00031+00005"; /* 300x250, created 5/5/09 */ google_ad_slot = "4236597451"; google_ad_width = 300; google_ad_height = 250; google_protectAndRun("ads_core.google_render_ad", google_handleError, google_render_ad);This article will explain how one can insert or save images into a sql server database table using asp.net FileUpload control. You may ask why we will save or store images into sql server database table instead of a server folder? The answer is its easy to use, easy to manage, easy to backup as well as easy programming. But one thing you have to keep in mind that you need to extend the size of your database rather than your regular size. Always deleting images from server folder is a hectic job where security will play a great role but if you store images into sql server database you can remove images or related images by issuing a simple delete sql command.

	
			01
			<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Save_Images.aspx.cs" Inherits="Save_Images" %>
		
			02
			 
			03
			<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
		
			04
			 
			05
			<html xmlns="http://www.w3.org/1999/xhtml" >
		
			06
			<head runat="server">
		
			07
			    <title>How to save images into sql server database</title>
		
			08
			</head>
		
			09
			<body>
		
			10
			    <form id="form1" runat="server">
		
			11
			    <div>
		
			12
			 
			13
			        Name:        
		
			14
			        <asp:TextBox runat="server" ID="txt_Image_Name"></asp:TextBox>
		
			15
			     
			16
			        Image Path:
		
			17
			        <asp:FileUpload runat="server" ID="FileUpload1" />
		
			18
			 
			19
			 
			20
			        <asp:Button runat="server" ID="cmd_Upload" Text="Upload Image" OnClick="cmd_Upload_Click" />
		
			21
			 
			22
			    </div>
		
			23
			    </form>
		
			24
			</body>
		
			25
			</html>

Now under cmd_Upload button write the below server side code. For your better understanding i have put full code here:

	
			01
			using System;
		
			02
			using System.Data;
		
			03
			using System.Configuration;
		
			04
			using System.Web;
		
			05
			using System.Data.SqlClient;
		
			06
			 
			07
			public partial class Save_Images : System.Web.UI.Page
		
			08
			{
		
			09
			    protected void Page_Load(object sender, EventArgs e)
		
			10
			    {
		
			11
			 
			12
			    }
		
			13
			    protected void cmd_Upload_Click(object sender, EventArgs e)
		
			14
			    {
		
			15
			        string s_Image_Name = txt_Image_Name.Text.ToString();
		
			16
			        if (FileUpload1.PostedFile != null && FileUpload1.PostedFile.FileName != "")
		
			17
			        {
		
			18
			            byte[] n_Image_Size = new byte [FileUpload1.PostedFile.ContentLength];
		
			19
			            HttpPostedFile Posted_Image = FileUpload1.PostedFile;
		
			20
			            Posted_Image.InputStream.Read(n_Image_Size, 0, (int)FileUpload1.PostedFile.ContentLength);
		
			21
			 
			22
			            SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["TestConnection"].ConnectionString);
		
			23
			 
			24
			            SqlCommand cmd = new SqlCommand();
		
			25
			            cmd.CommandText = "INSERT INTO Images(Name,[Content],Size,Type)" +
		
			26
			                              " VALUES (@Image_Name,@Image_Content,@Image_Size,@Image_Type)";
		
			27
			            cmd.CommandType = CommandType.Text;
		
			28
			            cmd.Connection = conn;
		
			29
			 
			30
			            SqlParameter Image_Name = new SqlParameter("@Image_Name", SqlDbType.VarChar, 500);
		
			31
			            Image_Name.Value = txt_Image_Name.Text;
		
			32
			            cmd.Parameters.Add(Image_Name);
		
			33
			 
			34
			            SqlParameter Image_Content = new SqlParameter("@Image_Content", SqlDbType.Image, n_Image_Size.Length);
		
			35
			            Image_Content.Value = n_Image_Size;
		
			36
			            cmd.Parameters.Add(Image_Content);
		
			37
			 
			38
			            SqlParameter Image_Size = new SqlParameter("@Image_Size", SqlDbType.BigInt, 99999);
		
			39
			            Image_Size.Value = FileUpload1.PostedFile.ContentLength;
		
			40
			            cmd.Parameters.Add(Image_Size);
		
			41
			 
			42
			            SqlParameter Image_Type = new SqlParameter("@Image_Type", SqlDbType.VarChar, 500);
		
			43
			            Image_Type.Value = FileUpload1.PostedFile.ContentType;
		
			44
			            cmd.Parameters.Add(Image_Type);
		
			45
			 
			46
			 
			47
			            conn.Open();
		
			48
			            cmd.ExecuteNonQuery();
		
			49
			            conn.Close();
		
			50
			        }
		
			51
			    }
		
			52
			
			}

So now i hope you can upload images into your sql server using FileUpload Asp.net control. In my next article i will show you how one can retrieve images from Sql Server into a GridView/DataList/Repeater control.