Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C# ASP
Hi,
I am using a generic handler to retrieve image from database.
i want multiple images to be displayed in a page. so i go for repeater control i dont know how to display all this image. so please help me.
 
Sample code:(This is my generic handler code)
 
public class showall : IHttpHandler 
{
    EHRS_DAL _objDAL = new EHRS_DAL();
    
    public void ProcessRequest (HttpContext context) 
    {
         if (context.Request.QueryString["ID"] != null)
         {
             try
             {
                 string ID = context.Request.QueryString["ID"].ToString();
                 //string imgno = context.Request.QueryString["to"].ToString();
                 //int No = Convert.ToInt32(imgno);
                 MySqlConnection connection = new MySqlConnection(ConfigurationManager.ConnectionStrings["constring"].ConnectionString);
                 connection.Open();
                 DataSet ds = new DataSet();
                 MySqlDataAdapter adap = new MySqlDataAdapter("select image,register_no from imagetable where file_type='image' and register_no ='" + ID + "'", connection);
                 adap.Fill(ds);
                 int count = ds.Tables[0].Rows.Count;
                 for (int i = 0; i < count; i++)
                 {
                    context.Response.BinaryWrite((Byte[])ds.Tables[0].Rows[i]["image"]);
                 }
                 connection.Close();
                 context.Response.End();  
             }
             catch
             {
             }
                  
        }
    }
 
    public bool IsReusable 
    {
        get 
        {
            return false;
        }
    }
 
    
}
 

I want to get image in repeater control.
 
code behind:
 protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
           id = Session["regno"].ToString();
           DataSet dset = new DataSet();
           connection.Open();
           MySqlDataAdapter adap = new MySqlDataAdapter("select register_no,image from imagetable where file_type='image' and register_no ='" + id + "'", connection);
           adap.Fill(dset);
           int totalcount = dset.Tables[0].Rows.Count;
           Repeater1.DataSource = dset.Tables[0];
           Repeater1.DataBind();
           connection.Close();
}
 
<asp:Repeater ID="Repeater1" runat="server" onitemdatabound="Repeater1_ItemDataBound">
                                <ItemTemplate>
                                 <asp:ImageButton ID="ImageButton1" ImageUrl='<%#"showall.ashx?ID="+ Eval("register_no") %>' runat="server" />
                                </ItemTemplate>
                                </asp:Repeater>
Posted 4-Jun-12 0:27am
Comments
kodeLogic at 4-Jun-12 6:50am
   
Hi Just put <%# Eval("image ") %> and concate it with a path.. Why are u using a handler ? you have the same query in your code behind.
parithi 2000 at 4-Jun-12 23:49pm
   
Thanks. i am using the handler to get the image but i don't know how to call that handler in repeater control.

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

see an example here[^]
  Permalink  

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

  Print Answers RSS
0 CPallini 550
1 Sergey Alexandrovich Kryukov 420
2 George Jonsson 288
3 Pheonyx 218
4 OriginalGriff 200
0 OriginalGriff 4,813
1 CPallini 3,850
2 Sergey Alexandrovich Kryukov 3,224
3 George Jonsson 2,552
4 Gihan Liyanage 2,186


Advertise | Privacy | Mobile
Web02 | 2.8.140905.1 | Last Updated 4 Jun 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100