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

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...

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 ! ");
}
}

2 Replies

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

Nitin Sontakke9y ago
See this:

http://csharp.net-informations.com/data-providers/csharp-sqlcommand-executenonquery.htm

Just google and you find everything.
0
Nitin Sontakke9y ago
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 ! ");
    }
}
0