Cannot convert type int to bool....?

Question

3.00/5 (1 vote)

See more:

I am using Active=0 to save the record this error will occurred "Cannot convert type int to bool".
the database active is using bit datatype..
please give me the solution

Thanks& Regrds
G Ravinder Reddy.

Posted 7-Jan-13 21:56pm

Gujula Ravindra Reddy

Add a Solution

Comments

_Amy 8-Jan-13 5:22am

Change the Tag as SQL Server, if your question deals with SQL.

4 solutions

Solution 1

I suspect that you're getting an error in your code, not from the database. In the DB, what you've done is fine, I use 1 and 0 for bits all the time. You can try using 'false' and see what happens, or post your code if you want us to fix it.

Posted 7-Jan-13 21:59pm

Christian Graus

Solution 3

I am totally agree with Christian Graus.
Here you can try with this alternative.

C#

bool YourBooleanVariable = Active == 0 ? false : true;

Here we can check the variable Active and if it is 0 then make your variable(working) as false/true as per needed.

This is Ternary Operator[^].

--Amit

Posted 7-Jan-13 22:15pm

_Amy

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Vishal.Shimpi144 · Accepted Answer · 2013-01-07T22:19:00

Solution 4

If you want 0 instaed of False the you have to modify your select query like

:

Select case(Active) 
            When 'False' Then 0
            When 'True' Then 1 End as Active
From YourTableName

if help full then accept the solution

Posted 7-Jan-13 22:19pm

Vishal.Shimpi144

Comments

_Amy 8-Jan-13 4:22am

Voted 3. Reason, Tag is ASP.net.

Yugal Pandya · Accepted Answer · 2013-01-07T22:02:00

Solution 2

if your datatype is bit then in frontend you should use datatype as bool and value will be assigned like Active=false or Active = true instead of Active=0.

Posted 7-Jan-13 22:02pm

Yugal Pandya

Comments

Gujula Ravindra Reddy 8-Jan-13 4:03am

Now i am using same but i want active =0 what is the solution...?

Yugal Pandya 8-Jan-13 4:18am

declare @Active bit
set @Active = 0
select @Active

from UI if you are passing true and false or 0 or 1 it doesn't matter but it's datatype must bool in UI, rest system will take care of bool datatype with bit datatype of database.