•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the ASP.NET section within the Web Development category of DaniWeb, a massive community of 401,534 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,391 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our ASP.NET advertiser: Lunarpages ASP Web Hosting
Views: 3527 | Replies: 19 | Solved
 |
•
•
Join Date: Apr 2007
Posts: 253
Reputation: 
Rep Power: 2
Solved Threads: 9
Posting Whiz in Training
HII,
i have a column in sql srver 2000 of data type bit.I have a checkbox in my page. i want to assign bit value to the column when the check box is checked and un checked,but i am getting errors when assigning true /false to the column.
i have a column in sql srver 2000 of data type bit.I have a checkbox in my page. i want to assign bit value to the column when the check box is checked and un checked,but i am getting errors when assigning true /false to the column.
•
•
Join Date: Jan 2008
Location: Punjab(....India....)
Posts: 31
Reputation:
Rep Power: 1
Solved Threads: 2
Light Poster
Datatype bit takes the value 0 or 1.....if true then 1
if false then 0
if false then 0
•
•
Join Date: Apr 2007
Posts: 253
Reputation:
Rep Power: 2
Solved Threads: 9
Posting Whiz in Training
when iam assigning false to the coulmn iam getting error
The name 'False' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.
here is my code
if (facultychecked.Checked == true)
{
anndept.announceToFaculty =true;
}
else
{
anndept.announceToFaculty =false;
}
AnnouncementManager.CreateAnnouncement(anndept);
}
The name 'False' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.
here is my code
if (facultychecked.Checked == true)
{
anndept.announceToFaculty =true;
}
else
{
anndept.announceToFaculty =false;
}
AnnouncementManager.CreateAnnouncement(anndept);
}
•
•
Join Date: Jan 2008
Location: Punjab(....India....)
Posts: 31
Reputation:
Rep Power: 1
Solved Threads: 2
Light Poster
yes this is because.......it consist only true or false.....if 1 then true and if 0 then false
ur code must b like this
if (facultychecked.Checked == true)
{
anndept.announceToFaculty =1;
}
else
{
anndept.announceToFaculty =0;
}
AnnouncementManager.CreateAnnouncement(anndept);
}
if u pass 1 (or greater than 1)to ur bit datatype column....then it make is as True
if u pass 0 to ur bit datatype column in sqlserver then....it make it as false.....
Pass (1 or 0 ) value.....it automatically....insert True or False
ur code must b like this
if (facultychecked.Checked == true)
{
anndept.announceToFaculty =1;
}
else
{
anndept.announceToFaculty =0;
}
AnnouncementManager.CreateAnnouncement(anndept);
}
if u pass 1 (or greater than 1)to ur bit datatype column....then it make is as True
if u pass 0 to ur bit datatype column in sqlserver then....it make it as false.....
Pass (1 or 0 ) value.....it automatically....insert True or False
•
•
Join Date: Apr 2007
Posts: 253
Reputation:
Rep Power: 2
Solved Threads: 9
Posting Whiz in Training
when iam using 1 and 0 iam getting error
CS0031: Constant value '1' cannot be converted to a 'bool'
if (facultychecked.Checked == true)
{
anndept.announceToFaculty =1;
}
else
{
anndept.announceToFaculty =0;
}
CS0031: Constant value '1' cannot be converted to a 'bool'
if (facultychecked.Checked == true)
{
anndept.announceToFaculty =1;
}
else
{
anndept.announceToFaculty =0;
}
•
•
Join Date: Jan 2008
Location: Punjab(....India....)
Posts: 31
Reputation:
Rep Power: 1
Solved Threads: 2
Light Poster
u can not assign 1 or 0 to a bool type variable.......
use Int type variable......and then assign 1 or 0
use Int type variable......and then assign 1 or 0
•
•
Join Date: Apr 2007
Posts: 253
Reputation:
Rep Power: 2
Solved Threads: 9
Posting Whiz in Training
can u explain more clearly
•
•
Join Date: Jan 2008
Location: Punjab(....India....)
Posts: 31
Reputation:
Rep Power: 1
Solved Threads: 2
Light Poster
do this thing.....take one int type variable....
Int32 i;
if (facultychecked.Checked == true)
{
i =1;
}
else
{
i=0;
}
and now u have ur value in "i" ....insert the value of "i" in ur bit type column of ur table....
Int32 i;
if (facultychecked.Checked == true)
{
i =1;
}
else
{
i=0;
}
and now u have ur value in "i" ....insert the value of "i" in ur bit type column of ur table....
•
•
Join Date: Apr 2007
Posts: 253
Reputation:
Rep Power: 2
Solved Threads: 9
Posting Whiz in Training
if (facultychecked.Checked == true)
{
k = 1;
}
else
{
k = 0;
}
anndept.announceToFaculty = k;
iam getting error
CS0029: Cannot implicitly convert type 'int' to 'bool'
{
k = 1;
}
else
{
k = 0;
}
anndept.announceToFaculty = k;
iam getting error
CS0029: Cannot implicitly convert type 'int' to 'bool'
•
•
Join Date: Jan 2008
Location: Punjab(....India....)
Posts: 31
Reputation:
Rep Power: 1
Solved Threads: 2
Light Poster
"anndept.announceToFaculty " this function is of bool type change this function dear.........
change this function dear........
change this function dear........
Last edited by btech_Saurabh : Jan 10th, 2008 at 7:06 am.
|
•
•
•
•
•
•
•
•
DaniWeb ASP.NET Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
- convert lower case letters to uppercase and vice-versa (C++)
- Help with Creating a Command Line Menu (C++)
- SQL insert help!! (VB.NET)
- Array problem (C#)
- HELP!!! Weird problem... (C++)
- Truth Table (Computer Science and Software Design)
- Conversion and searching with a string help (C++)
- I've got Trojan.Holax... is this bad? (Viruses, Spyware and other Nasties)
- not-a-virusadware (Viruses, Spyware and other Nasties)
- modifying all of the instances in an array at once (Java)
Other Threads in the ASP.NET Forum
- Previous Thread: .net nutch.
- Next Thread: Hi Help me i am new to asp.net
