I have a gridview control getting boolean data from a database. These fields are show as checkboxes. My problem is that the @FieldName in the update does not seem to be returning a boolean value.

My update statement has multiple boolean fields and is longer that the example below:

UPDATE employees SET isAdmin = @isAdmin, hasPicture = @hasPicture,... WHERE empolyeeID = @employeeID

This update works if I use this
UPDATE employees SET isAdmin = true, hasPicture = false,... WHERE empolyeeID = @employeeID

I have tried cBool(@isAdmin) but this always returns true even if the check box is not checked. I even tried the old SQL CONVERT ut that did not work.