Hi Jeff,
First of all, I would like to confirm my understanding of your issue. From
your description, I understand that when you have bounded a checkbox to bit
column, you cannot add a new record to the Dataset. If there is any
misunderstanding, please feel free to let me know.
As far as I know, this is a known issue. When the checkbox is bound to a
bit column and its default value is not set, the field value has to be
DBNull when a new row is added. However, the checked property knows nothing
about DBNull, so it fails. The workaround is to add a default value to the
bit column in either schema or code.
Here is a KB article for more information on this issue. HTH.
http://support.microsoft.com/default.aspx?scid=KB;EN-US;326440
Kevin Yu

Signature
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."
Jeff Grundy - 26 Oct 2004 15:47 GMT
That KB article addressed the problem.
> Hi Jeff,
>
[quoted text clipped - 17 lines]
> "This posting is provided "AS IS" with no warranties, and confers no
> rights."
Kevin Yu [MSFT] - 27 Oct 2004 06:09 GMT
Hi Jeff,
Thanks for sharing your experience with all the people here. If you have
any questions, please feel free to post them in the community.
Kevin Yu

Signature
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."