how to count the clicks of an image?

Hima

hi Gudmrng..
I Am fresher to .Net, I have a doubt that, in my website i have to display the no.of people clicking on the like image for the conversation!!!!. I used repeater to display the conversation. Plzzz anyone Helpme.... Here Im attaching my code and stored procedure.

Source View:

Comments

<%--

--%>

Subject:

Event:

Created Date:

CodeView:

protected void RepDetails_ItemCommand(object source, RepeaterCommandEventArgs e)
{
ImageButton imglike = sender as ImageButton;
Repeater RepDetail1 = (Repeater)imglike.NamingContainer;
Label lbllike = (Label)RepDetail1.FindControl("lblcount");
lblcount = lbllike.Text;
try
{
con.Open();
SqlCommand cmd = new SqlCommand("usp_likecount", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = con;
cmd.Parameters.AddWithValue("@EventID", lblID.Text);
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
RepDetails.DataSource = ds;
RepDetails.DataBind();
}

Stored Procedure:

USE [*****]
GO
/****** Object: StoredProcedure [dbo].[usp_likecount] Script Date: 02/24/2014 11:38:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[usp_likecount]
(@EventID int
,@EvenConvID int)
AS
BEGIN
DECLARE @like int
SELECT @like=Likes FROM EventConv WHERE EventID=@EventID AND EvenConvID=@EvenConvID
UPDATE EventConv SET [Likes]=@like+1 WHERE EvenConvID=@EvenConvID
END

21 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sai Prasad Anumolu12y ago
Try This Example Sir http://stuffuser.blogspot.in/2013/12/count-image-button-clicks-to-display-in.html
Hima12y ago
still the same thing as first...!
12y ago
Please change that too and what values you're getting in lbllike.Text?
count = Convert.ToInt32( lbllike.Text);
Hima12y ago
ho, actually im storing it in stored procedure sir Act after changing the code also it is giving an error" 'System.Convert' does not contain a definition for 'ToInt'" at this line" count = "Convert.ToInt(lbllike.Text);" Thanks in advance
12y ago
Here is the updated code.
But, you're not passing Count variable to the stored procedure. Are you using in some other places?

protected void RepDetails_ItemCommand(object source, RepeaterCommandEventArgs e)
{
ImageButton imglike = sender as ImageButton;
Repeater RepDetail1 = (Repeater)imglike.NamingContainer;
Label lbllike = (Label)RepDetails.FindControl("lblcount");
count = Convert.ToInt( lbllike.Text);
try
{
con.Open();
SqlCommand cmd = new SqlCommand("usp_likecount", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = con;
cmd.Parameters.AddWithValue("@EventID", lblID.Text);
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
RepDetails.DataSource = ds;
RepDetails.DataBind();

}
catch (Exception ex)
{
lblerror.Text = ex.Message;
}

con.Close();
Hima12y ago
Here is my Whole code sir:

PLz Have a look,
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;

namespace Attri
{
public partial class COnversation : System.Web.UI.Page
{
int count = 0;
SqlConnection con = new SqlConnection(@"Data Source=******; Initial Catalog=*****; user= sa; PassWord=*****; Integrated Security=true");
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BindRepeaterData();
}
}

protected void btnSubmit_Click(object sender, EventArgs e)
{

con.Open();
SqlCommand cmd = new SqlCommand("usp_EventConv_insert", con);
cmd.CommandType = CommandType.StoredProcedure;

cmd.Parameters.AddWithValue("@Comment", txtComment.Text);
cmd.Parameters.AddWithValue("@DateTime", DateTime.Now);
cmd.Parameters.AddWithValue("@EventID", "1");
cmd.ExecuteNonQuery();
con.Close();
txtComment.Text = string.Empty;
BindRepeaterData();

}
protected void BindRepeaterData()
{
con.Open();
SqlCommand cmd = new SqlCommand("usp_Event_Conv", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = con;
cmd.Parameters.AddWithValue("@EventID", lblID.Text);
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
RepDetails.DataSource = ds;
RepDetails.DataBind();

}

protected void RepDetails_ItemCommand(object source, RepeaterCommandEventArgs e)
{
ImageButton imglike = sender as ImageButton;
Repeater RepDetail1 = (Repeater)imglike.NamingContainer;
Label lbllike = (Label)RepDetails.FindControl("lblcount");
count.Text = lbllike.Text;
try
{
con.Open();
SqlCommand cmd = new SqlCommand("usp_likecount", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = con;
cmd.Parameters.AddWithValue("@EventID", lblID.Text);
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
RepDetails.DataSource = ds;
RepDetails.DataBind();

}
catch (Exception ex)
{
lblerror.Text = ex.Message;
}

con.Close();

}
public object imgbtnlike { get; set; }

public ImageButton sender { get; set; }

}
}
Lakshmanan Sethu Sankaranarayan12y ago
have you declared lblCount as string? In that case your old code is correct. Please post your declaration section also..

Hima12y ago

Thank You SIr for the Reply,
But now im getting this error,
Here count is integer..

'string' does not contain a definition for 'Text' and no extension method 'Text' accepting a first argument of type 'string' could be found

Line 70:         //Repeater RepDetail1 = (Repeater)imglike.NamingContainer; Line 71:         Label lbllike = (Label)RepDetails.FindControl("lblcount"); Line 72:         lblcount.Text = lbllike.Text; Line 73:         try Line 74:         {

Lakshmanan Sethu Sankaranarayan12y ago
Hi, Are you getting error now?
Hima12y ago
ok sir. but why im getting error in that line.!!

Thanks&Regards
Lakshmanan Sethu Sankaranarayan12y ago
Hey Hima. Please change the code lblcount = lbllike.Text; to lblcount.Text = lbllike.Text;

Hima12y ago

Ok sir.
This is the line I am getting Error

Server Error in '/Sports' Application.
Object reference not set to an instance of an object.Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.

Source Error: 

Line 68:     { Line 69:         ImageButton imglike = sender as ImageButton; Line 70:         Repeater RepDetail1 = (Repeater)imglike.NamingContainer; Line 71:         Label lbllike = (Label)RepDetail1.FindControl("lblcount"); Line 72:         lblcount = lbllike.Text;

Source File: c:\Users\crm3\Documents\Visual Studio 2010\Sports\Conversation.aspx.cs    Line: 70 

Stack Trace: 

[NullReferenceException: Object reference not set to an instance of an object.]    Conversation.RepDetails_ItemCommand(Object source, RepeaterCommandEventArgs e) in c:\Users\crm3\Documents\Visual Studio 2010\Sports\Conversation.aspx.cs:70    System.Web.UI.WebControls.Repeater.OnItemCommand(RepeaterCommandEventArgs e) +108    System.Web.UI.WebControls.Repeater.OnBubbleEvent(Object sender, EventArgs e) +68    System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +37    System.Web.UI.WebControls.RepeaterItem.OnBubbleEvent(Object source, EventArgs e) +123    System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +37    System.Web.UI.WebControls.ImageButton.OnCommand(CommandEventArgs e) +111    System.Web.UI.WebControls.ImageButton.RaisePostBackEvent(String eventArgument) +176    System.Web.UI.WebControls.ImageButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10    System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13    System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36    System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1565 

Version Information: Microsoft .NET Framework Version:2.0.50727.5477; ASP.NET Version:2.0.50727.5479

Lakshmanan Sethu Sankaranarayan12y ago
Hi Hima,

Please let us know the statement which gives you error?
Hima12y ago
Yah, in this line iam getting error sir Line:70 "Repeater RepDetail1 = (Repeater)imglike.NamingContainer;"
12y ago
Sorry, what statment is present on line number 70 in your code behind file?
Hima12y ago
sry sir, im nor getting u.!!
12y ago
What statement is there in line # Conversation.aspx.cs:70 ?

Hima12y ago

STACK TRACE:

[NullReferenceException: Object reference not set to an instance of an object.]    Conversation.RepDetails_ItemCommand(Object source, RepeaterCommandEventArgs e) in c:\Users\crm3\Documents\Visual Studio 2010\Sports\Conversation.aspx.cs:70    System.Web.UI.WebControls.Repeater.OnItemCommand(RepeaterCommandEventArgs e) +108    System.Web.UI.WebControls.Repeater.OnBubbleEvent(Object sender, EventArgs e) +68    System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +37    System.Web.UI.WebControls.RepeaterItem.OnBubbleEvent(Object source, EventArgs e) +123    System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +37    System.Web.UI.WebControls.ImageButton.OnCommand(CommandEventArgs e) +111    System.Web.UI.WebControls.ImageButton.RaisePostBackEvent(String eventArgument) +176    System.Web.UI.WebControls.ImageButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10    System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13    System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36    System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1565

12y ago
Can you please post the stacktrace here?
Hima12y ago
thanks for ur reply sir. Im getting "NULLREFERENCE EXCEPTION :Object reference not set to an instance of an object." sir.
thanks&Regards.
12y ago
Hi ,
Are you getting any error?

Thanks
Murali