button click in repeater increments the value in database

MsDotNet raja

10y1.8k.NET

Hi, I have a column called Likes in my db, and in repeater i have a button, if a user clicks on the button the value in db should increase by +1 on every click and the button should display the number of likes in count(as 32 likes).

asp code:

C# code:

protected void rptCustomers_ItemDataBound(object sender, RepeaterItemEventArgs e)

{

using (MySqlConnection con = new MySqlConnection(connString))

{

using (MySqlCommand cmd = new MySqlCommand("UPDATE articles SET Likes = Likes+1 WHERE Pid=" + Pid, con))

{

using (con)

{

con.Open();

cmd.ExecuteNonQuery();

con.Close();

}

Please correct my code, thanx in advance.

4 Replies

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

Manas Mohapatra10y ago
Accepted answer
Make sure that you are sending correct value of Pid to MySQL db

Secondly check your connection string which database server you pointing to.

Make sure that your code executed properly with out any exception.
+1
MsDotNet raja10y ago
everything is correct but the main thing is button is in repeater. The click event is not performing well. Searched many tutorials and googled also, but there is no correct method is performing my task. Can u please send me some code which fires this button click and stores the values(and increases with +1 on every click) in the db. Thanx in advance.
+1
MsDotNet raja10y ago
with this code on button click, the value is not incrementing in my db. but if i run the update query seperately in mysql the value is increasing in the particular record. where the mistake in code?
0
Manas Mohapatra10y ago
You are updating the likes column value on button click. Where is the problem now.

After updating the value you need to reload the repeater to show updated value.
+1