|
web
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Bit and booleanI 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 reidarT wrote:
> I have an sql db with one field set as bit . No, bit is the right field. Show us code how you set the value and get > 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 > > it from the db. 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? -- Show quoteHide quoteJoseph Bittman Microsoft Certified Solution Developer Microsoft Most Valuable Professional -- DPM Blog/Web Site: http://CactiDevelopers.ResDev.Net/ "Chris" <no@spam.com> wrote in message news:OxCyuhD1GHA.4448@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. Can you set the field as a Boolean type?
-- Show quoteHide quoteDennis 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 > > > 
Other interesting topics
HEX char -- > its comlement
Extending an Abstract class that uses a Generic Parameter Check for Updates Get all forms contained in another project Try to delete a worksheet in Excel WebBrowser Control can't create dll properly File Not Accessed Code Analyzers Best way to check things in background in MDI window |
|||||||||||||||||||||||
