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. Anybody please help me.