Re: Data Type for a CheckBox

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance





"Christof Nordiek" wrote:

> "BigAl" <BigAl@xxxxxxxxxxxxxxxxxxxxxxxxx> schrieb im Newsbeitrag
> news:C0345446-1547-4703-9770-316C43B17DCC@xxxxxxxxxxxxxxxx
> >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
>
>
>
Thanks...As it turned out, I was doing everything right but had other
issues...stuff that drives programmers crazy. I was mixing controls from dev
express and asp.net and using a dev express datacontroller. aspx.net
controls don't mix well with a dev express datacontroller.
.



Relevant Pages

  • Re: Access 97 to SQL
    ... The timestamp is a data type, ... the timestamp field does not need to be part of the SELECT ... > converted the Access tables to a SQL Server 2000 database and linked the ... > the way I set up Autonumbering in SQL? ...
    (microsoft.public.access.externaldata)
  • Re: Data Types
    ... > moved to SQL Server and I don't know the best newsgroups yet. ... > Does a Unique Identifier data type take up less storage space than a 32 ... A uniqueidentifier uses 16 bytes. ... but I'm looking at the data types and think that the TimeStamp ...
    (microsoft.public.sqlserver.programming)
  • Re: The tricky thing is that you can even multiply by numeric to make it
    ... Arithmetic overflow error converting expression to data type numeric. ... I'm using SQL Server 2008 version 10.50.1600. ... I have been trying to use the ROUND() function: ... Is an expression of the exact numeric or approximate numeric data type category, except for the bit data type. ...
    (microsoft.public.sqlserver.programming)
  • Re: Update string too long?
    ... search through the newsgroups, as wells as google.com for the web. ... Pro SQL Server 2000 Database Design - ... Beginner posts are the most helpful and it is ... what is the data type and length for the ...
    (microsoft.public.sqlserver.programming)
  • Re: How Can I Write a SQL Server Function that Returns a Memo Data Type in Access?
    ... When I use the function in a view and link to the view through ODBC, ... Text data type. ... LONGTEXT, LONGCHAR, MEMO, and NOTE aren't recognized by SQL Server. ...
    (comp.databases.ms-access)