Uploading images to the database, retrieves images from database and displays it in the data grid. To display images we are using handler.ashx file

Products.aspx

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class products : System.Web.UI.Page
     {
        SqlConnection cn = new SqlConnection("Data Source=COMPUTER10; Initial Catalog=shoppingtrolly; Integrated Security=true");
    protected void Page_Load(object sender, EventArgs e)
    {
      
        cn.Open();
        SqlCommand cmd = new SqlCommand("select PID,PName,BName,MRP,Offp from productdetails", cn);
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        DataSet dt = new DataSet();
        da.Fill(dt);
        gdproduct.DataSource = dt;
        gdproduct.DataBind();
        cn.Close();
    }
    protected void btnsearch_Click(object sender, EventArgs e)
    {

    }
    protected void Item_Click(Object sender, DataGridCommandEventArgs e)
    {
        cn.Open();
       
        SqlCommand cmd1 = new SqlCommand("select PID,PName from productdetails", cn);
        SqlDataAdapter da1 = new SqlDataAdapter(cmd1);
        DataSet ds1 = new DataSet();
        da1.Fill(ds1);
        if (((LinkButton)e.CommandSource).CommandName == "SelectItem")
        {

            string debug = "";

            try
            {
                for (int i = 0; i < ds1.Tables[0].Rows.Count; i++)
                {
                    string key = gdproduct.DataKeys[e.Item.ItemIndex].ToString();
                    if (key == gdproduct.DataKeys[e.Item.ItemIndex].ToString())
                    {
                        lblm.Text = gdproduct.DataKeys[e.Item.ItemIndex].ToString();
                        Session["v"] = lblm.Text;
                        Response.Redirect("prdetails.aspx");
                    }
                }
            }
            catch (Exception exc)
            {
                debug = exc.Message;
            }
        }
    }

    protected void ResetPageIndex(DataGrid gdproduct, DataView view)
    {
       
        if ((gdproduct.CurrentPageIndex != 0) && (((gdproduct.CurrentPageIndex) * gdproduct.PageSize) >= view.Count))
        {
           
            if ((view.Count % gdproduct.PageSize) == 0)
            {
    gdproduct.CurrentPageIndex = (view.Count / gdproduct.PageSize) - 1;
            }
            else         
  {
       gdproduct.CurrentPageIndex = (view.Count / gdproduct.PageSize);
            }
        }
    }
}

ImageHandler.ashx

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

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

public class ImageHandler : IHttpHandler {
   
    public void ProcessRequest (HttpContext context) {
        //context.Response.ContentType = "text/plain";
        //context.Response.Write("Hello World");
        //int ImID = 2;
       string imageid=context.Request.QueryString["PrID"];
        SqlConnection cn=new SqlConnection("Data Source=COMPUTER10; Initial Catalog=shoppingtrolly; Integrated Security=true");
        cn.Open();
        SqlCommand cmd=new SqlCommand("select PImage from productdetails where PID="+imageid, cn);
        SqlDataReader dr=cmd.ExecuteReader();
        dr.Read();
        context.Response.BinaryWrite((Byte[])dr[0]);
        cn.Close();
        context.Response.End();
    }
 
    public bool IsReusable {
        get {
            return true;
        }
    }

}

HTML code

<asp:DataGrid ID="gdproduct" style="z-index:101; top:300px; left:50px;" Width="700px" runat="server" DataKeyField="PID" AutoGenerateColumns="False" OnItemCommand="Item_Click" BorderWidth="3px" BorderStyle="Inset" >        
<Columns>
<asp:TemplateColumn HeaderText="Image">
<ItemTemplate >
<asp:ImageButton ID="imgbtn" runat="server" ImageUrl='<%# "ImageHandler.ashx?PrID="+Eval("PID") %>' />
</ItemTemplate>
    <HeaderStyle ForeColor="Chocolate" Font-Bold="true" Font-Size="X-Large" />
</asp:TemplateColumn>
<asp:BoundColumn HeaderText = "ProductID" DataField="PID">
    <HeaderStyle ForeColor="Chocolate" Font-Bold="true" Font-Size="X-Large" />
</asp:BoundColumn>
<asp:BoundColumn DataField="PName" HeaderText="ProductName">
    <HeaderStyle ForeColor="Chocolate" Font-Bold="true" Font-Size="X-Large" />
</asp:BoundColumn>
<asp:BoundColumn DataField="BName" HeaderText="BrandName">
    <HeaderStyle ForeColor="Chocolate" Font-Bold="true" Font-Size="X-Large" />
</asp:BoundColumn>
<asp:BoundColumn DataField="MRP" HeaderText="MaximumPrice">
    <HeaderStyle ForeColor="Chocolate" Font-Bold="true" Font-Size="X-Large" />
</asp:BoundColumn>
<asp:BoundColumn DataField="Offp" HeaderText="OfferPrice">
    <HeaderStyle ForeColor="Chocolate" Font-Bold="true" Font-Size="X-Large" />
</asp:BoundColumn>
<asp:ButtonColumn Text="MoreDetail" HeaderText="Moredetail" CommandName="SelectItem">
    <HeaderStyle ForeColor="Chocolate" Font-Bold="true" Font-Size="X-Large" />
</asp:ButtonColumn>
</Columns>
    <HeaderStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False"
        Font-Underline="False" />

</asp:DataGrid>