Click here to Skip to main content
15,886,075 members
Please Sign up or sign in to vote.
4.00/5 (1 vote)
See more:
Hi,
I have did following to my code. But my image cannot be display. It is show red x in gridview.
My cclist data looks like
VB
0x010007004454465320504D000000000000000000000000000000000000000000000000000000000000000000000000000000

What am i missing?

Imagehandler.ashx

C#
public void ProcessRequest (HttpContext context) {

    if (context.Request.QueryString["machinenamedisplay"] == null)
        return;
    string connStr = ConfigurationManager.ConnectionStrings["connectionString"].ConnectionString.ToString();

    string machinenamedisplay = "SINGULATION # 2";
    using (SqlConnection conn = new SqlConnection(connStr))
    {
        using (SqlCommand cmd = new SqlCommand("SELECT top 100 CCList from dbo.Obs_PMChkList_1 where machinenamedisplay = @machinenamedisplay", conn))
        {
            cmd.Parameters.Add(new SqlParameter("@machinenamedisplay", machinenamedisplay));
            conn.Open();
            using (SqlDataReader reader = cmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection))
            {
                reader.Read(); context.Response.BinaryWrite((Byte[])reader[reader.GetOrdinal("CClist")]);
                reader.Close();
            }
        }
    }
}
public bool IsReusable
{
    get { return true; }

}



Page_Load

C#
string connStr = ConfigurationManager.ConnectionStrings["connectionString"].ConnectionString.ToString();
       DataTable table = new DataTable();
       using (SqlConnection conn = new SqlConnection(connStr))
       {
               string sql = "SELECT top 100 machinenamedisplay,CCList from dbo.Obs_PMChkList_1";
               using (SqlCommand cmd = new SqlCommand(sql, conn))
           {
               using (SqlDataAdapter ad = new SqlDataAdapter(cmd))
               {
                   conn.Open(); ad.Fill(table); conn.Close();
               }
           }
       }
       gvImages.DataSource = table;
       gvImages.DataBind();



aspx

XML
<asp:GridView Width="500px" ID="gvImages" runat="server" AutoGenerateColumns="False" >

<Columns>

<asp:BoundField HeaderText = "machinenamedisplay" DataField="machinenamedisplay" />

<asp:TemplateField HeaderText="Image">

<ItemTemplate>

<%--<img src="ImageHandler.ashx?machinenamedisplay=<%# Eval("machinenamedisplay").ToString() %>"  width="150" height="100" />--%>
 <asp:Image runat="server" ID="pic1"
              ImageUrl='<%# "~/ImageHandler.ashx?machinenamedisplay=" + Eval("machinenamedisplay") %>'>
              </asp:Image>

</ItemTemplate>

</asp:TemplateField>

</Columns>

</asp:GridView>
Posted

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900