Data Type for a CheckBox

[Guest]

I am using a SQL server database and am using a Check Box on my .aspx screen.
What data type should I use when I design my table? I tried bit but When I
ran the program and Checked one of the check boxes I got a msg: True is not a
valid value for int16. I changed the data type to small int, re-ran the
program, checked the box and got: Entered value cannot be converted to int16.

 

[Pohihihi]

you can check the condition/state of checkbox and then send value from your
side e.g. 1 for true and 0 or false.

 

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,

You should use bit:

//Store in the DB
com.Parameters.Add("@internalDOTReq", SqlDbType.Bit).Value =
this.internaldotrequest?1:0;

//retrieve from DB
bool internaldotrequest = (bool)reader["internalDOTReq"];


cheers,

 

[Christof Nordiek]

I am using a SQL server database and am using a Check Box on my .aspx
screen.
What data type should I use when I design my table? I tried bit but When
I
ran the program and Checked one of the check boxes I got a msg: True is
not a
valid value for int16. I changed the data type to small int, re-ran the
program, checked the box and got: Entered value cannot be converted to
int16.

Hi BigAl,

it shuold work with datatype bit in SQL Server and Boolean in the DataSet!!
Hope that helps