button click in repeater increments the value in database

Question

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.

Manas Mohapatra · 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.

MsDotNet raja · Answer

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.

Manas Mohapatra · Answer

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.

MsDotNet raja · Answer

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?