How to count the button clicks

bex · February 12th, 2009, 04:14 PM

Hi there i am trying to count the clicks in a button which i have done but i need to update a table so next time the user log in the label count will display the hits.
this is what i have

Code:

sent.Text = Val(sent.Text) + 1
Dim con AsNew SqlConnection(ConfigurationManager.ConnectionStrings("test").ConnectionString)
Dim cmdd AsNew SqlCommand("UPDATE Users SET NumberEmailSent = '" & Me.sent.Text & " ' Where Name= @Name")
cmdd.Parameters.Add("@Name", Data.SqlDbType.NVarChar, 50).Value = Me.lblUser.Text
cmdd.Connection = con
con.Open()
cmdd.ExecuteNonQuery()
con.Close()

what this does it updates the lable +1 and the table at the same time but if i log out and log in the label is reset to 0 and if i click the button the table will alsow be reset to 1.
i need to be able to add them up
thanks

alliancejhall · February 12th, 2009, 08:14 PM

What's the code you are using to set the label value? you can't just expect the label to set it's own value? i assume you are doing something similar to

Code:

Dim con As New SqlConnection(ConfigurationManager.ConnectionStrings("test").ConnectionString)
Dim cmdd As New SqlCommand("select NumberEmailSent from Users Where Name= @Name")
Dim dr as SqlDataReader = Nothing
cmdd.Parameters.Add("@Name", Data.SqlDbType.NVarChar, 50).Value = Me.lblUser.Text
cmdd.Connection = con
con.Open()
dr = cmdd.ExecuteReader()

DR.Read()
If DR.HasRows() = True Then
Me.lblClicks.Text = DR("NumberEmailSent").ToString
End If

con.Close()

bex · February 13th, 2009, 05:34 AM

thank you that did it