How to i save checkbox value to database ADO

guanxian · December 6th, 2005, 07:21 AM

How to i save checkbox value to database ADO??

BrianWren · December 13th, 2005, 06:19 PM

Code:

    If ctrl.checked = True Then
        cmd.CommandText = "UPDATE table     " & _
                          "SET field = TRUE " & _
                          "WHERE ID =  whatever "
    Else
        cmd.CommandText = "UPDATE table     " & _
                          "SET field = TRUE " & _
                          "WHERE ID =  whatever "
    End If
    cmd.Execute