<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>
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(); }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)