Implement Like Unlike button by Incrementing Decrementing count in database in ASP.Net

Question

Incrementing and decrementing a count table by button click when a user clicks a button the count table will increment by 1 and when the same user clicks the button the second time it will decrement by 1

dharmendr · Accepted Answer

I have modified your code please checkHTMLltdivgt    ltaspButton Text34LikeUnLike34 runat34server34 ID34btnLikeUnLike34 OnClick34btnLikeClick34 gt    ltbr gt    ltaspDataList runat34server34 ID34dlCount34gt        ltItemTemplategt            lttablegt                lttrgt                    lttdgt                        UserId                    lttdgt                    lttdgt                        ltaspLabel ID34Label134 Text39ltEval34USERID34 gt39 runat34server34gtltaspLabelgt                    lttdgt                lttrgt                lttrgt                    lttdgt                        Count                    lttdgt                    lttdgt                        ltaspLabel ID34Label234 Text39ltEval34COUNTSTATUS34 gt39 runat34server34gtltaspLabelgt

dharmendr · Answer

You get this error because you only supply two value to the table and not all If you only want to supply two value you also need to include the column name in the query You have to write your insert query like belowINSERT INTO IncrementDecrement FromIdCOUNTSTATUS VALUES FromId COUNTSTATUS

Implement Like Unlike button by Incrementing Decrementing count in database in ASP.Net

Company

Explore

Follow us

Contact Us