Example of Image Upload

hanusoft · #1 (**permalink**) 09-20-2007, 12:28 AM

Here we are uploading images in File System and storing path in the database.

Code (ImageUpload.aspx.cs) :-
private void Button1_Click(object sender, System.EventArgs e)
{
// Here I am uploading images in Images folder of C drive.
int intResult=0;
string strPath = @"c:\Images\"+Path.GetFileName(File1.PostedFile.Fi leName);
SqlConnection con = new SqlConnection("server=.;uid=sa;database=pubs;pwd=" );
SqlCommand com = new SqlCommand("Insert into Category(name,imagepath) values(@name,@imagepath)",con);
com.Parameters.Add("@name",TextBox1.Text);
com.Parameters.Add("@imagepath",strPath);
con.Open();
intResult = Convert.ToInt32(com.ExecuteNonQuery());
if(intResult != 0)
{
File1.PostedFile.SaveAs(strPath);
Response.Write("Record Inserted.");
}
}

S.Vinothkumar · #2 (**permalink**) 09-20-2007, 02:18 AM

Hi,

You can upload image in to DB as byte array as follows.

Code:

 System.Drawing.Bitmap b = (System.Drawing.Bitmap)System.Drawing.Image.FromStream(imageStream);

byte[] byteImg = BmpToBytes(b);

Code:

private byte[] BmpToBytes(System.Drawing.Image bmp)
    {
        MemoryStream ms = null;
        byte[] bmpBytes = null;
        try
        {
            ms = new MemoryStream();
            // Save to memory using the Jpeg format
            bmp.Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg);

            // read to end
            bmpBytes = ms.GetBuffer();
        }
        catch (Exception ex)
        {
            return null;
        }
        finally
        {
            bmp.Dispose();
            if (ms != null)
            {
                ms.Close();
            }
        }
        return bmpBytes;
    }

You can save this byte array into db. Similarly you can conver this byte array in to image easily as follows,

Code:

MemoryStream memoryStream = new MemoryStream();
                memoryStream.Write(byteImg, 0, byteImg.Length);
                System.Drawing.Image imagen = System.Drawing.Image.FromStream(memoryStream);
                Response.ContentType = "image/Jpeg";

imagen.Save(Response.OutputStream, System.Drawing.Imaging.ImageFormat.Jpeg);
                connection.Close();

that's it....

GDevakii · #3 (**permalink**) 09-20-2007, 10:59 PM

WebForm1.aspx
<%@ Page language="c#" src="WebForm1.aspx.cs" AutoEventWireup="false" Inherits="UploadFile.WebForm1" %>
<HTML>
<body>
<form id="Form1" enctype="multipart/form-data" method="post" runat="server">
<INPUT id="FileInput" style="Z-INDEX: 101; LEFT: 32px; WIDTH: 552px; POSITION: absolute; TOP: 24px; HEIGHT: 24px" type="file" size="72" name="File1" runat="server">
<asp:button id="cmdUpload" style="Z-INDEX: 102; LEFT: 32px; POSITION: absolute; TOP: 72px" runat="server" Text="Upload"></asp:button>
<asp:Label id="lblInfo" style="Z-INDEX: 103; LEFT: 32px; POSITION: absolute; TOP: 128px" runat="server" Width="608px" Height="72px" Font-Names="Verdana" Font-Size="Medium" Font-Bold="True"></asp:Label></form>
</body>
</HTML>
WebForm1.aspx.cs
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;

namespace UploadFile
{
/// <summary>
/// Summary description for WebForm1.
/// </summary>
public class WebForm1 : System.Web.UI.Page
{
protected System.Web.UI.WebControls.Button cmdUpload;
protected System.Web.UI.WebControls.Label lblInfo;
protected System.Web.UI.HtmlControls.HtmlInputFile FileInput;

private void Page_Load(object sender, System.EventArgs e)
{
// Only accept image types.
FileInput.Accept = "image/*";
}

#region Web Form Designer generated code
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: This call is required by the ASP.NET Web Form Designer.
//
InitializeComponent();
base.OnInit(e);
}

/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.cmdUpload.Click += new System.EventHandler(this.cmdUpload_Click);
this.Load += new System.EventHandler(this.Page_Load);

}
#endregion

private void cmdUpload_Click(object sender, System.EventArgs e)
{
if (FileInput.PostedFile.FileName == "")
{
lblInfo.Text = "No file specified.";
}
else
{
try
{
string serverFileName = Path.GetFileName(FileInput.PostedFile.FileName);
//FileInput.PostedFile.SaveAs(@"c:\" + serverFileName);
FileInput.PostedFile.SaveAs(MapPath(".") + serverFileName);
lblInfo.Text = "File " + serverFileName;
lblInfo.Text += " uploaded successfully.";
}
catch (Exception err)
{
lblInfo.Text = err.Message;
}
}

}
}
}

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Fckeditor Image Upload Path	bluesky	PHP Programming	1	03-24-2008 06:12 AM
Convert image to other image format using CODEC in .NET 3.0	Mramesh	C# Programming	0	02-07-2008 03:33 AM
How to create an image from panel background Image	S.Vinothkumar	C# Programming	1	10-22-2007 03:52 AM
How to upload an image to DB in ASP.Net?	mobilegeek	ASP and ASP.NET Programming	6	09-18-2007 11:18 PM
Image Upload problem	ewriter	PHP Programming	4	07-13-2007 05:18 AM