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.

Datatype bit takes the value 0 or 1.....if true then 1
if false then 0

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);

}

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

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;
}

u can not assign 1 or 0 to a bool type variable.......
use Int type variable......and then assign 1 or 0

can u explain more clearly

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....

if (facultychecked.Checked == true)
{
k = 1;

}
else
{
k = 0;
}
anndept.announceToFaculty = k;
iam getting error
CS0029: Cannot implicitly convert type 'int' to 'bool'

"anndept.announceToFaculty " this function is of bool type change this function dear.........
change this function dear........