Bit and boolean

[reidarT]

I have an sql db with one field set as bit .
I have a window form with a datagrid.
The field is shown as a checkbox.
My problem is that the value doesn't show in the field
They are all blank even if there are both true and false in the table.
Am I using a wrong kind of field type in my table?

reidarT

 

[Chris]

I have an sql db with one field set as bit .
I have a window form with a datagrid.
The field is shown as a checkbox.
My problem is that the value doesn't show in the field
They are all blank even if there are both true and false in the table.
Am I using a wrong kind of field type in my table?

reidarT

No, bit is the right field. Show us code how you set the value and get
it from the db.

 

[Guest]

Can you set the field as a Boolean type?

 

[Joseph Bittman MVP MCSD]

Sept. 9, 2006

Assuming Chris is right that Bit is OK (I don't know personally), then are
you sure that you have your checkbox column "bound" correctly to the DB
column?

--

Joseph Bittman
Microsoft Certified Solution Developer
Microsoft Most Valuable Professional -- DPM

Blog/Web Site: http://CactiDevelopers.ResDev.Net/