Programming error

[Ganpad]

object upt;
        myconn.Open();
        mycmd = new SqlCommand("select CId from customer where CId='" + TextBox1.Text + "'", myconn);
        upt= mycmd.ExecuteScalar();
        string up = Convert.ToString(upt);
        if (up == TextBox1.Text)
        {
            Label7.Text = "Row is Updated";
        }
        else
        {
            Label7.Text = "Row is not Updated";
        }
        mycmd = new SqlCommand("update customer set CName='" + TextBox2.Text + "',CAddress='" + TextBox3.Text + "',CPhone='" + TextBox4.Text + "',CEmail='" + TextBox5.Text + "',CCCardNo='" + TextBox6.Text + "'where CId='"+TextBox1.Text+"'", myconn);
        mycmd.ExecuteNonQuery();
        myconn.Close();
        display();
        clear();
 

i write this code in button click event.When data is updated,

label shows "Row is not Updated". But actually it has to show "Row is Updated" msg.


But record is updated. It is showing msg only wrong. Please give me a

solution for this ASAP. Though condition is correct, it jumped to else. I'm getting confused. please help me.

[MedIt]

Try catching the exception, the exception message might give you a clue....

[Plater]

I would bet that if you set a break point here and looked at both values, one of them is not going to be what you think it is.

if (up == TextBox1.Text)
 

You also might want to wait until the row is actually updated, before changing your label messages.