a aditya

a aditya

  • NA
  • 1
  • 1.2k

Count of likes for image

Dec 8 2013 9:17 AM

i am creating an image gallery (images stored in Images folder,path saved in db) in the gridview

Each imagename is saved in dbwith and uinque id and the columnname : storyid.

can anyone tell me how to bind the indiviudal images "like" count in the lblcount

<body> <form id="form1" runat="server"> <asp:ScriptManager runat="server" ID="SM1"> </asp:ScriptManager> <div>     <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" Font-Names="Arial"         OnRowCommand="GridView1_RowCommand1">         <Columns>             <asp:TemplateField>                 <ItemTemplate>                     <asp:UpdatePanel runat="server" ID="up1" UpdateMode="Conditional">                         <ContentTemplate>                             <asp:Button runat="server" ID="IncreaseButton" Text="Like" CommandName="Increase"                                 CommandArgument="<%# ((GridViewRow) Container).RowIndex %>" />                                 <asp:Label runat="server" ID="lblCount"></asp:Label>                             <div style="display: none;">                                 <asp:Label Text="<%#Bind('StoryId')%>" ID="lblStoryid" runat="server"></asp:Label>                             </div>                         </ContentTemplate>                     </asp:UpdatePanel>                 </ItemTemplate>             </asp:TemplateField>             <asp:ImageField DataImageUrlField="FilePath" ControlStyle-Width="100" ControlStyle-Height="100"                 HeaderText="Preview Image">                 <ControlStyle Height="100px" Width="100px"></ControlStyle>             </asp:ImageField>             <asp:TemplateField>                 <HeaderTemplate>                     <asp:Label Text="Description" runat="server" Visible="False"></asp:Label>                 </HeaderTemplate>                 <ItemTemplate>                     <asp:Label Text="<%#Bind('Description')%>" ID="lblImageid" runat="server"></asp:Label>                 </ItemTemplate>                 <EditItemTemplate>                 </EditItemTemplate>             </asp:TemplateField>         </Columns>     </asp:GridView> </div> </form>

public partial class Gallery : System.Web.UI.Page

{

private void bindimage() {     DataTable dt = new DataTable();     String strConnString = System.Configuration.ConfigurationManager.         ConnectionStrings["dbconnection"].ConnectionString;     string strQuery = "select * from story";       SqlCommand cmd = new SqlCommand(strQuery);     SqlConnection con = new SqlConnection(strConnString);     SqlDataAdapter sda = new SqlDataAdapter();     cmd.CommandType = CommandType.Text;     cmd.Connection = con;     try     {         con.Open();         sda.SelectCommand = cmd;         sda.Fill(dt);         GridView1.DataSource = dt;         GridView1.DataBind();     }     catch (Exception ex)     {         Response.Write(ex.Message);     }     finally     {         con.Close();         sda.Dispose();         con.Dispose();     } } 


Answers (1)