5,696,576 members and growing! (12,796 online)
Email Password   helpLost your password?
Web Development » Charts, Graphs and Images » Images and multimedia     Intermediate License: The Code Project Open License (CPOL)

Save An Image Into SQL Server 2000 Database

By vivekthangaswamy

How to upload files to Web pages in ASP.NET? How to read an image from a database using ADO.NET and display it in a Web page?
C#, SQL, Windows, .NET 1.1, .NET, ASP.NET, SQL Server, Visual Studio, SQL 2000, VS.NET2003, DBA, Dev

Posted: 25 Feb 2005
Updated: 25 Feb 2005
Views: 281,077
Bookmarked: 107 times
Announcements
Loading...



Search    
Advanced Search
Sitemap
65 votes for this Article.
Popularity: 7.25 Rating: 4.00 out of 5
7 votes, 10.8%
1
2 votes, 3.1%
2
2 votes, 3.1%
3
19 votes, 29.2%
4
35 votes, 53.8%
5

Abstract

.NET is the new distributed computing platform developed by Microsoft and ASP.NET is its programming model for web development. The intent of this article is to get a good experience in developing data driven ASP.NET Web Forms applications by means of a real world application. This application will teach you how to save an image file into a database and how to retrieve it from the database. It uses ADO.NET as the data access mechanism, C# as the development language, and SQL Server 2000 as the backend database.

Overview of the Solution

Normally, images are saved in the web server folder, not in the database; this is for larger file size category. In some cases like, in bank, for example, they scan the user signatures as image files and save that file into the database.

  • Database schema

    MS SQL Server 2000 is used as the backend database for this small demonstration. And I used a special data type in SQL Server called image. The image data type is used to save the image into the database.

  • Controls used in this application
    • System.Web.UI.HtmlControls.HtmlInputFile
    • System.Web.UI.WebControls.TextBox
    • System.Web.UI.WebControls.Button
  • Namespaces used in this application:
    using System.Data.SqlClient;
    using System.Drawing;
    using System.Data;
    using System.IO;
    using System.Drawing.Imaging;

Solution with Code

Use the HtmlInputFile class, which you can declare an instance of with an <input type="file" runat="server"/> tag. The following example is a complete ASPX file that lets a user upload an image file and a comment describing the image. The OnUpload method writes the image and the comment to a table named Pictures in a SQL Server database named iSense.

// Source Code for Save the image file into the database


public void OnUpload(Object sender, EventArgs e)
{
    // Create a byte[] from the input file

    int len = Upload.PostedFile.ContentLength;
    byte[] pic = new byte[len];
    Upload.PostedFile.InputStream.Read (pic, 0, len);
    // Insert the image and comment into the database

    SqlConnection connection = new 
      SqlConnection (@"server=INDIA\INDIA;database=iSense;uid=sa;pwd=india");
    try
    {
        connection.Open ();
        SqlCommand cmd = new SqlCommand ("insert into Image " 
          + "(Picture, Comment) values (@pic, @text)", connection);
        cmd.Parameters.Add ("@pic", pic);
        cmd.Parameters.Add ("@text", Comment.Text);
        cmd.ExecuteNonQuery ();
    }
    finally 
    {
        connection.Close ();
    }
}

The above created function is called using the onClick property of a button.

How do I read an image from a database using ADO.NET and display it in a Web page?

Here, I used the web page to display the image and not any other control. The following is the code for displaying the image from the database.

private void Page_Load(object sender, System.EventArgs e)
{
    // Put user code to initialize the page here

    MemoryStream stream = new MemoryStream ();
    SqlConnection connection = new 
      SqlConnection (@"server=INDIA\INDIA;database=iSense;uid=sa;pwd=india");
    try
    {
        connection.Open ();
        SqlCommand command = new 
          SqlCommand ("select Picture from Image", connection);
        byte[] image = (byte[]) command.ExecuteScalar ();   
        stream.Write (image, 0, image.Length);
        Bitmap bitmap = new Bitmap (stream);
        Response.ContentType = "image/gif";
        bitmap.Save (Response.OutputStream, ImageFormat.Gif);
    } 
    finally
    {
        connection.Close ();
        stream.Close ();
    }
}

The GDI+ functions offer a rich set of features for managing and modifying image data. This article's examples offer only a glimpse into the functionality you can leverage using the classes available in the System.Drawing and System.Drawing.Imaging namespaces. For example, you can develop applications for storing and managing image files on the Web, or you can provide a simple, easily deployed application that enables users to manipulate images.

How to run this application? First, create a virtual directory and put the project files into the virtual directory. And then change the server name, database name, and table name in the following statement.

SqlConnection connection = new SqlConnection
        ("server=localhost;database=mypictures;uid=sa;pwd=");

and publish the project to get the best results.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

About the Author

vivekthangaswamy



Occupation: Architect
Location: India India

Other popular Charts, Graphs and Images articles:

Article Top
Sign Up to vote for this article
You must Sign In to use this message board.
FAQ FAQ Noise ToleranceSearch Search Messages 
 Layout  Per page   
 Msgs 1 to 25 of 62 (Total in Forum: 62) (Refresh)FirstPrevNext
GeneralHow to display image???membersmetaljuan9:01 29 Oct '08  
GeneralStore and Retrieve image without using temp file...memberanandmmsoft21:41 12 Oct '08  
GeneralNice Articlememberirshadmohideen4:58 30 Aug '08  
Generalthank youmember7sepehr22:07 22 Jun '08  
Generalsql image applicationmemberbapu28897:53 8 Jun '08  
Generalcreate image in sql HLPPP!!!@!@!memberyaozhong18:36 8 May '08  
GeneralHow to resize (zoom in) Image before save to sqlmemberDoan Quynh1:22 21 Apr '08  
GeneralGood workmemberAlex Archambault11:18 28 Nov '07  
Generalvery goood topicmembermkazim852:42 26 Oct '07  
GeneralGood article [modified]memberBino B23:06 4 Oct '07  
GeneralStore Image In SQL 2000memberAbhijit Salokhe0:03 17 Sep '07  
GeneralRe: Store Image In SQL 2000membervivekthangaswamy3:41 18 Sep '07  
Questioninvalid paramer(stream) exceptionmembervinuparli21:18 23 May '07  
AnswerRe: invalid paramer(stream) exceptionmembervivekthangaswamy22:28 4 Jun '07  
AnswerRe: invalid paramer(stream) exceptionmemberThe Knowledge2:52 5 Oct '07  
QuestionSave image through DataBase through InagePathmembergs_dhaliwal1:51 27 Feb '07  
AnswerRe: Save image through DataBase through InagePathmembervivekthangaswamy3:02 27 Feb '07  
Generalretriving image from sqlserver2000 using c#member18:43 16 Jan '07  
QuestionSave and retreive files (as word document, excel files) in the databasemembersagi399920:55 20 Dec '06  
AnswerRe: Save and retreive files (as word document, excel files) in the databasememberPatrish10:23 5 Jan '07  
AnswerRe: Save and retreive files (as word document, excel files) in the databasememberkrishnakumark0:40 7 Feb '07  
Questiondo program in c# + asp.net+sqlmemberal_wrood0:10 17 Oct '06  
AnswerRe: do program in c# + asp.net+sqlmembervivekthangaswamy7:38 20 Oct '06  
GeneralVery useful onememberAravind.Kumar3:36 19 Sep '06  
GeneralRe: Very useful onemembervivekthangaswamy7:39 20 Oct '06  

General General    News News    Question Question    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

PermaLink | Privacy | Terms of Use
Last Updated: 25 Feb 2005
Editor: Smitha Vijayan
Copyright 2005 by vivekthangaswamy
Everything else Copyright © CodeProject, 1999-2008
Web15 | Advertise on the Code Project