15 pts.
 about checkbox
Iam just at the very basic level of entering a boolean value(yes/no) for the check box cheked value in to a database with field check...for this Iam using a string variable checkvalue and proceeding like this private sub submitbtn_click(.......) dim checkvalue as string="" if checkbox1.checked= true then checkvalue="yes" else if checkbo2.checked=true then checkvalue="no" end if dim strsql as string="insert into table (.....,check)values(........,'" & checkvalue & "')" con.open() dim cmd as sqlcommand(con,strsql) cmd.executenonquery() con.close() end sub but this approach is showing me an syntax error at check which i couldn't find any error in my code... is it the correct programming practice or any thing wrong with my code....plz suggest me the right way to store the checked value into the database regards Anu

Software/Hardware used:
ASKED: April 14, 2008  11:00 PM
UPDATED: April 15, 2008  12:08 PM

Answer Wiki:
If you are trying to put this into a field with a data type of BIT (which would be the database equivalent of boolean) then you have to put in a 0 or a 1. These are the only two values which a field of the BIT data type supports. 0 = No, 1 = Yes.
Last Wiki Answer Submitted:  April 15, 2008  12:46 am  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _