Click here to Skip to main content
15,921,226 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I want to create art gallery. And I am using datalist to display images of arts in gallery.And it working. Now I want to display that art details when I click on Image. But nothing is happening after clicking on that image. Please help.
Here is my code:
gallery.aspx:
XML
<asp:UpdatePanel ID="up1" runat="server">
        <ContentTemplate>
    <asp:DataList ID="DataList1" runat="server" RepeatDirection="Horizontal" RepeatColumns="4" OnItemCommand="DataList1_ItemCommand" DataKeyField="artsId"  >
        <ItemTemplate>
            <table>
                <tr>
                    <td>
                        <asp:Label ID="Label1" runat="server" Text='<%# Eval("artsId") %>' Visible="false"></asp:Label>
                    </td>
                    <td>
                        <asp:ImageButton ID="ImageButton1" runat="server" Text='<%# Eval("mainImage") %>' Height="200px" Width="200px" CommandName="ImageButton1" ImageUrl='<%# Eval("mainImage") %>'   />
                    </td>
                </tr>
            </table>
             <br />
       </ItemTemplate>
</asp:DataList>
            </ContentTemplate>
        </asp:UpdatePanel>


and my C# code is:
SqlConnection con = new SqlConnection("Data Source=SNEHAL-PC\\SNEHAL1;Initial Catalog=artsondeals;Integrated Security=True");

  protected void Page_Load(object sender, EventArgs e)
  {
      if (!IsPostBack)
      {
          binddata();
      }

  }
  protected void binddata()
  {
      DataSet ds = new DataSet();
      DataTable dt = new DataTable();
      con.Open();
      string cmdr = "select arts.artsId,artdetails.mainImage from artdetails INNER JOIN arts ON artdetails.artsId=arts.artsId";
      SqlCommand cmd = new SqlCommand(cmdr, con);
      SqlDataAdapter da = new SqlDataAdapter(cmd);
      da.Fill(dt);
      DataList1.DataSource = dt;
      DataList1.DataBind();
  }

  protected void DataList1_ItemCommand(object source, DataListCommandEventArgs e)
  {
      DataSet ds = new DataSet();
      DataTable dt = new DataTable();
      String str = "select artdetails.artDescription,arts.Name from artdetails INNER JOIN arts ON artdetails.artsId=arts.artsId";
      SqlDataAdapter ad = new SqlDataAdapter(str, con);
      ad.Fill(dt);
      GridView gd = new GridView();
      gd.DataSource = dt;
      gd.DataBind();
  }
Posted
Comments
[no name] 10-May-14 5:34am    
what have done for image click event? show that code
Member 10724668 10-May-14 5:43am    
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
DataSet ds = new DataSet();
DataTable dt = new DataTable();
con.Open();
string cmdr = "select arts.Name,arts.OriginalPrice,artdetails.artDescription,artdetails.artValidity from artdetails INNER JOIN arts ON artdetails.artsId=arts.artsId";
SqlCommand cmd = new SqlCommand(cmdr, con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);



}
Peter Leow 10-May-14 6:13am    
Did you forget to add a WHERE clause say: WHERE arts.artsid="id of that art piece" ?
Silvercorer 11-May-14 1:39am    
try adding 'OnCommand="ImageButton1_Click" ' in imagebutton html block. Hope it will help.

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