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]

reidarT wrote:

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.

[Dennis]

Can you set the field as a Boolean type?
--
Dennis in Houston
"reidarT" wrote:

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

[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/
"Chris" <[e-mail] in message
news:Ox**************@TK2MSFTNGP04.phx.gbl...

reidarT wrote:

>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.