How to Retrieve Images from Database (In Layer Architecture)

Here you will learn how to Retrieve Images from a Database (In a Layer Architecture).

Now I want retrieve these Images from the database and display in a Grid View.

These are the products I want to retrieve from the database.



Presentation Layer:

Take a page SearchComputers.aspx

Under SearchComputers.aspx page:

<asp:GridView ID="GVImages" runat="server" AutoGenerateColumns="false"
            HeaderStyle-BackColor="red" HeaderStyle-ForeColor="white" Height="278px"
            Width="476px">
              <Columns>
              <asp:BoundField DataField="ProductId" HeaderText="ID" Visible="false"/>
              <asp:BoundField DataField="ProductType" HeaderText="ProductType" />
              <asp:TemplateField HeaderText="Image">
              <ItemTemplate>
                <asp:ImageButton ID="ImageButton1" runat="server"
                         ImageUrl='<%# "Handler.ashx?id="+ Eval("ProductId")%>' Width="200" Height="100"/>
        </ItemTemplate>
              </asp:TemplateField>
              </Columns>                   

<HeaderStyle BackColor="Red" ForeColor="White"></HeaderStyle>
               </asp:GridView>

Under SearchComputers.aspx page.cs :

protected void Page_Load(object sender, EventArgs e)
    {      
     // SelectProducts is class.Now we should create a object for that class.
 
        SelectProducts b = new SelectProducts();
        DataSet ds = new DataSet();
        ds = b.FetchAllImagesInfo();
        GVImages.DataSource = ds;
        GVImages.DataBind();

    }

If you want to retrieve images from a database you should use a Generic Handler Class.

That class name is Handler.ashx

Under Handler.ashx Class

<%@ WebHandler Language="C#" Class="Handler" %>

using System;
using System.Web;
using System.Data.SqlClient;
using System.Configuration;
using System.Data;
using System.IO;

public class Handler : IHttpHandler
{

    public void ProcessRequest(HttpContext context)
    {

        string id = context.Request.QueryString["id"];
        SqlConnection con = new SqlConnection();
        con.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings
                              ["ConnectionString"].ConnectionString;

        // Create SQL Command
        SqlCommand cmd = new SqlCommand();
        cmd.CommandText = "Select Image from Products   where ProductId ='" + id+ "'";
        cmd.CommandType = System.Data.CommandType.Text;
        cmd.Connection = con;

         SqlParameter ProductId = new SqlParameter
                            ("@ProductId", System.Data.SqlDbType.Int);
        ProductId.Value = context.Request.QueryString["id"];
        cmd.Parameters.Add(ProductId);
        con.Open();
        SqlDataReader dReader = cmd.ExecuteReader();
        dReader.Read();
        context.Response.BinaryWrite((byte[])dReader["Image"]);
        dReader.Close();
        con.Close();

    }

    public bool IsReusable
    {
        get
        {
            return false;
        }
    }
}

Business Access Layer:

Take a Class i.e. SelectProducts.cs

Under SelectProducts.cs class

public DataSet FetchAllImagesInfo()
     {
         return ds = SqlHelper.ExecuteDataset(clsConnection.Connection,              CommandType.StoredProcedure, "sp_GetProductsWithImage");
    }
// Here "sp_GetProductsWithImage" is the stored procedure Name.

Data Access Layer:

public class clsConnection
{
      public clsConnection()
      {
            //
            // TODO: Add constructor logic here
            //
      }
    public static string Connection = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
}

Under Web.config:

<connectionStrings>

<add name="ConnectionString" connectionString="user Id=sa;Password=123;DataBase=RentalShopping;Data Source=server2" providerName="System.Data.SqlClient"/>

</connectionStrings>

//Here write your database name,userid,password,datasource.

Under DataBase:

Create one database i.e RentalShopping.Under Database create one table.I have created one table i.e Products.

CREATE TABLE [dbo].[Products]
(
      [ProductId] [int] IDENTITY(101,1) NOT NULL,
      [ProductType] [varchar](50) NULL,
      [Image] [image] NULL
}

This is the stored Procedure

USE [RentalShopping]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
Create PROCEDURE [dbo].[sp_GetProductsWithImage]
as
begin
select *from Products
end

If you want to store images into a database, see my article Click Here