Please Help me. I guess it is simple, but not for me
I wish to use a checkbox to send two values :
value 1 if checked, and value 0 if unchecked
At the moment it sends the correct boolean value when the box is checked
But NOT when it is unchecked.
In that later case, the Update SQL sentence returns an error message saying
Incorrect syntax near the word WHERE
(Instead of UPDATE table1 SET oven=0 WHERE .....)

By the way, I wish to use boolean values in that column because I need to link it with another table, and that join does not respond to "Null" values.

Thank you in advance for you answer if you can, and happy Easter

what is ur database???
did u check if that 1 or 0 value cud be inserted into the database ???
if it takes only true or false value then sending of numberic value might have caused this error

The following example displays "True" or "False" in a Label Web server control to reflect the latest change in a CheckBox control.
' Visual Basic
Private Sub CheckBox1_CheckedChanged(ByVal sender As _
   System.Object, ByVal e As System.EventArgs) Handles _
   CheckBox1.CheckedChanged
   Label1.Text = "CheckBox1 selection is: " & CheckBox1.Checked
End Sub

// C#
private void CheckBox1_CheckedChanged(object sender, EventArgs e)
{
   Label1.Text = "CheckBox1 selection is: " + CheckBox1.Checked;
}

the above is fr msdn

hope it helps

Thanks,
My data base is SQL, and i can insert 0 or 1 values
I looked at the private Sub checkBox you propose. However, I am too much of a beginner to use it yet. I have to learn it first.
So I finaly decided to turn the problem around and create a link "many to one" on the database, so that, even if I have a null value, it should give an answer.
Thanks any ways.
:)