I am working on a project using C# and need help in this.

Question

I have made a like button using image button. When I click on this Like button then the user who has given that answer should get one point for that answer and it should be stored in the Points table in Database.I want to use update query for this.Please help me out in this.. Waiting for your response...

Nitin Sontakke · Answer

See this: http://csharp.net-informations.com/data-providers/csharp-sqlcommand-executenonquery.htm Just google and you find everything.

Nitin Sontakke · Answer

Have you tried anything yet? If yes please do share. Otherwise please be very very specific about the area where you are stuck. It is very difficult to imagine what exactly you want. private void updateLikes(String user_id) { string connetionString = null ; SqlConnection cnn ; SqlCommand cmd ; string sql = null ; connetionString = Data Source=ServerName;Initial Catalog=DatabaseName;User ID=UserName;Password=Password ; sql = UPDATE table_name set like_count = like_count + 1 WHERE user_id = ' + user_id + '; cnn = new SqlConnection(connetionString); try { cnn.Open(); cmd = new SqlCommand(sql cnn); cmd.ExecuteNonQuery(); cmd.Dispose(); cnn.Close(); MessageBox.Show (  ExecuteNonQuery in SqlCommand executed !! ); } catch (Exception ex) { MessageBox.Show( Can not open connection !  ); } }