Show Image in Image Control from database

Question

0.00/5 (No votes)

See more:

Hi ,

I was trying to do an activity in which i want to show the image into a image control.

I am having a table in SQL server 2008 :
Table name:employee_detail
Columns:
[Emp_id] [varchar](50) NOT NULL,
[Emp_init] [varchar](50) NOT NULL,
[Emp_fname] [varchar](200) NOT NULL,
[Emp_lname] [varchar](200) NOT NULL,
[Emp_add1] [varchar](200) NULL,
[Emp_add2] [varchar](200) NULL,
[Emp_telephone] [varchar](10) NULL,
[Emp_mobile] [varchar](10) NULL,
[Emp_email] [varchar](100) NULL,
[Emp_gender] [varchar](1) NULL,
[DOB] [datetime] NULL,
[Image1] [image] NULL

I inserted the values into this table. But when i am trying to retrieve the image from this table then my code is running fine but no image is fetch

My Handler file is as follows:

C#

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

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

public class Handler : IHttpHandler {

    connectionclass cs = new connectionclass();
    public void ProcessRequest (HttpContext context)
    {
        if (context.Request.QueryString["id"] != null)
        {
            string constr = ConfigurationManager.ConnectionStrings["test_empConnectionString"].ConnectionString;
            cs.con = new System.Data.SqlClient.SqlConnection();
            cs.con.Open();
            cs.cmd = new SqlCommand("select Image1 from employee_detail where Emp_id=@Emp_id;", cs.con);
            cs.cmd.Parameters.AddWithValue("@Emp_id", context.Request.QueryString["Emp_id"].ToString());
            cs.dr = cs.cmd.ExecuteReader();
            cs.dr.Read();
            context.Response.BinaryWrite((byte[])cs.dr["Image1"]);
            cs.dr.Close();
            cs.con.Close();
        }
        else
        {
            context.Response.Write("No Image Found");
        }
     //   context.Response.ContentType = "text/plain";
     //   context.Response.Write("Hello World");
    }

    public bool IsReusable {
        get {
            return false;
        }
    }

}

My aspx.cs file is as follows:

C#

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;


public partial class Login_screen : System.Web.UI.Page
{
    connectionclass cs = new connectionclass();

    protected void Page_Load(object sender, EventArgs e)
    {
        string usr = (string)(Session["username"]);
        cs.con = new SqlConnection(ConfigurationManager.ConnectionStrings["test_empConnectionString"].ConnectionString);
        cs.cmd = new SqlCommand("Select Emp_fname +' '+Emp_lname from Employee_detail where Emp_id =(Select Emp_id from login1 where Username='"+usr+"')",cs.con);
        cs.con.Open();
        lblUsername.Text= Convert.ToString(cs.cmd.ExecuteScalar());
        cs.con.Close();

        cs.con = new SqlConnection(ConfigurationManager.ConnectionStrings["test_empConnectionString"].ConnectionString);
        cs.con.Open();
        cs.cmd = new SqlCommand("Select * from employee_detail where Emp_id =(Select Emp_id from login1 where Username='" + usr + "')", cs.con);
        cs.dr = cs.cmd.ExecuteReader();
        cs.dr.Read();
        if(cs.dr.HasRows)
        {
            UserImage.ImageUrl = "~/Handler.ashx?Emp_id=" + usr;
        }
        cs.con.Close();


    }
    protected void btnlogout_Click(object sender, EventArgs e)
    {
        Session["username"] = "";
        Response.Redirect("Login_page.aspx");
    }
}

my aspx file is as follows:

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="User_welcome_screen.aspx.cs" Inherits="Login_screen" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head  runat="server">
    <title></title>
    <style type="text/css">
        #welcome
        {
            height: 168px;
        }
    </style>
</head>
<body>
    <form id="form1"  runat="server">
    <div id="welcome">
    <table align="left">
    <tr>
    <td>
    <asp:Label ID="lblWelcome" Text="Welcome " runat="server"></asp:Label><asp:Label ID="lblUsername" runat="server"></asp:Label>
    </td>
    </tr>
    </table>
    <table align="right">
    <tr>
    <td>
        <asp:Button ID="btnlogout" runat="server" Text="Logout" 
            onclick="btnlogout_Click" />
    </td>
    <td></td><td></td><td></td>
    <td>
        <asp:Button ID="btnchngpass" runat="server" Text="Change Password" />
    </td>
    </tr>
    </table>
        <br />
        <br />
        
        <div>
        <table>
        <tr>
        <td>
        <asp:Image ID="UserImage" runat="server" ImageUrl='<%"~/Handler.ashx?Emp_ID="+Eval("Emp_ID")%>' />
        </td>
        </tr>
        </table>
        </div>
    <div align="left" style="height: 117px">
    
    <table align="left" rules="cols" 
            style="font-family: Arial, Helvetica, sans-serif; font-size: medium; font-weight: bold; table-layout: auto; border-collapse: separate">
    <tr>
        <td>
        <a href="Attend_leave.aspx">Attendence\Leave System</a>
            <br />
        </td>
    </tr>
    
    <tr>
        <td>
        <a href="Edit_employee_detail.aspx">Update Personal Details</a>
            <br />
        </td>
    </tr>
    
    <tr>
        <td>
        <a href="#">Mail to Admin</a>
            <br />
        </td>
    </tr>
    
    </table>
    </div>
    </div>
   
    
   
    </form>
</body>
</html>

Please help me on this!!!

Posted 2-Feb-13 0:24am

preetpal kapoor

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

OriginalGriff · Answer 1 · 2013-02-02T00:59:00

Solution 1

Here is how I do it: A generic Image-From-DB class for ASP.NET[^]

Posted 2-Feb-13 0:59am

OriginalGriff

Comments

preetpal kapoor 2-Feb-13 7:07am

I tried your way but getting same result.... Dn't knw what to do??

Pallavi Waikar · Answer 2 · 2013-02-02T01:57:00

Solution 2

i think u r problem is here...

C#

string constr = ConfigurationManager.ConnectionStrings["test_empConnectionString"].ConnectionString;
            cs.con = new System.Data.SqlClient.SqlConnection();
            cs.con.Open();
            cs.cmd = new SqlCommand("select Image1 from employee_detail where Emp_id=@Emp_id;", cs.con);

u r not setting connectionString property of con....

u have to do..

C#

cs.con.ConnectionString=constr;
cs.con.Open();

Posted 2-Feb-13 1:57am

Pallavi Waikar

Updated 2-Feb-13 1:58am

v2

Comments

preetpal kapoor 2-Feb-13 11:51am

Hi Pallavi,

Thanks for your reply but i am getting same output by making the changes referred by you.

Pallavi Waikar 2-Feb-13 12:25pm

go through following link...it it help you a lot..... http://www.dotnetcurry.com/ShowArticle.aspx?ID=129....compare ur code with this code...