check boxes and sql server

[dave2k]

i have a database table and each row has a int field called set. If it's value is 1 it is set, and 0 it isn't. what i want to do is databind this to a html table, with a cell with a checkbox in for each database row, and if a user checks a box, the corresponding row field gets set to 0.

how can i do this?

[superuser]

You really should be using the bit datatype and not integer for bits. If the datatype is of bit then a gridview sees bits as checkboxes:)

HTH