Why Won't This Work!?

I have a textbox and a checkbox on a form and I'd like to add both values to a db. The textbox value gets inserted fine but I'm having trouble with the checkbox. Any ideas would be greatly appreciated.





Thanks





Form1 is the column in my db.














SqlCommand myCmd = new SqlCommand();





myCmd.Parameters.Add("@ClientCode",SqlDbType.VarChar).Value = TextBox2.Text;





myCmd.CommandText = "UPDATE table SET Form1 = 'Yes' WHERE ClientCode = @ClientCode";








sqlConnection1.Open();


myCmd.Connection = sqlConnection1;





if( CheckBox1.Checked == true)


{


myCmd.ExecuteNonQuery();


}





sqlConnection1.Close();