Click here to Skip to main content
15,893,508 members
Articles / Web Development / ASP.NET
Tip/Trick

storing and retriving images from database using ASP.NET

Rate me:
Please Sign up or sign in to vote.
2.67/5 (3 votes)
1 Dec 2011CPOL 16K   1   4
Code for storing and retrieving images from database using ASP.NET.
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Data;
using System.Data.SqlClient;
using System.Web.UI.WebControls;

public partial class Default2 : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

        int id = Convert.ToInt32(Request.QueryString["imagId"]);

        if (id > 0)
        {

            //connect to the db
            SqlConnection conn = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=F:\Examples\ImageExamples\Images1\ImageStoringAndRetrivingUsingImageConrtol\App_Data\Database1.mdf;Integrated Security=True;User Instance=True");

            //sql command to select the image with id of 1
            SqlCommand cmd = new SqlCommand("SELECT * FROM Images WHERE ImgId=@ImgId", conn);
            cmd.CommandType = CommandType.Text;

            //select the image with ImgId of 1
            cmd.Parameters.AddWithValue("@ImgId", id);

            using (conn)
            {
                //open the connection
                conn.Open();
                //send the sql query to select the image and store the results in a sqldatareader
                SqlDataReader rdr = cmd.ExecuteReader();
                //read the data
                if (rdr.Read())
                {
                    //store the image binary data in a byte array
                    Byte[] imgData = (byte[])rdr["ImgBin"];
                    //setup the image type to be displayed
                    Response.ContentType = (rdr["ImgType"].ToString());
                    //output the image to the page
                    Response.OutputStream.Write(imgData, 0, imgData.Length);
                }
            }

        }

    }
    }

License

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


Written By
India India
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Comments and Discussions

 
GeneralMy vote of 3 Pin
Member 1098252813-Oct-14 0:47
Member 1098252813-Oct-14 0:47 
GeneralBut i am using ms access as a database Pin
Janardan Pandey23-Jan-12 23:32
Janardan Pandey23-Jan-12 23:32 
GeneralRe: Actually i don't know much about ms access database but i wi... Pin
D.rajasekharreddy31-Jan-12 3:13
D.rajasekharreddy31-Jan-12 3:13 
GeneralReason for my vote of 1 This has been seen hundreds of times... Pin
mdarco1-Dec-11 21:28
mdarco1-Dec-11 21:28 
Reason for my vote of 1
This has been seen hundreds of times. Please don't write super simple articles just because it is good for your CV to have an article on CodeProject.

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.