I have a table with three columns: int, varchar(100) and bit. I have the grid displaying values correctly and inserting rows, but the problem is with the bit field. It will display a 1 or 0 for the value correctly. When I select to edit a row the checkbox or textfield, I have tried both, will display the value. The issue is when I update, nothing happens to that field. Same thing when I add, it always puts 1 into the database, regardless is the checkbox is checked or 0 is in the textbox. I have tried editing the varchar field and it successfully updates.

Thank you.