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,
--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation
"BigAl" <Bi***@discussions.microsoft.com> wrote in message
news:1A**********************************@microsof t.com...
"BigAl" wrote:
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.
Thanks for the quick response, however, what data type should I use in my
Sql Server database? Also, I use a dataset/dataview for fetches and
updates.
When I check the checkbox will the dataset be automatically updated?