Re: Data Type for a CheckBox

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC 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: 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)
  • Re: Recordset Update Error
    ... SQL Server bit fields need to be declared as ... Add a timestamp field to each table. ... The timestamp is a data type, ... 'Opens Recordset ...
    (microsoft.public.access.externaldata)