How to resolve this error

Question

0.00/5 (No votes)

See more:

, +

C#

string stryisactive = Convert.ToString(arrLIst[7]);
                if (stryisactive == "true")
                {
                    stryisactive = "1";
                }
                else
                {
                    stryisactive = "0";
                }

System.FormatException: String was not recognized as a valid Boolean. Error

C#

var parameteristaxexempted = new SqlParameter("@istaxexempted", SqlDbType.Bit);
           parameteristaxexempted.Value = istaxexpted;
           myCommand.Parameters.Add(parameteristaxexempted).Value.ToString();

Failed to convert parameter value from a String to a Boolean. i got this error

Posted 12-Jul-12 22:44pm

2011999

Updated 13-Jul-12 0:33am

v2

Add a Solution

Comments

jeyamothi 13-Jul-12 5:19am

arrLIst[7] contain the value as string or boolean

Shemeer NS 13-Jul-12 10:02am

whats the value in arrLIst[7] ? whats the value in istaxexpted ?

5 solutions

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)

StianSandberg · Answer 1 · 2012-07-12T22:49:00

When you send a parameter to sql with datatype "bit", you will have to send a boolean value (not a string). Try parse your string to a bool before you add it to your sql-parameter

C#

var mystring = "true";
bool myBool;
if(bool.TryParse(mystring, out myBool))
{
    // parsing was ok! I can now use my myBool variable!
    parameteristaxexempted.Value = myBool;
}
else
{
    // could not parse mystring to bool.. Something is wrong with the string value
}

rizwan muhammed khan gouri · Answer 2 · 2012-07-13T01:56:00

hello
when you want to pass value as bool why you converting it into string than pass again converting bool
you can used like.

C#

if(bool.TryParse(arrLIst[7], out myBool))
{
    // parsing was ok! I can now use my myBool variable!
    parameteristaxexempted.Value = myBool;
}
else
{
    // could not parse mystring to bool.. Something is wrong with the string value
}

i hope your problem will solve if not than comment

darshan_ur · Answer 3 · 2012-07-12T22:47:00

Hi,

Rather then having a string and then converting it into string values, Initialize the parameter to assign as Boolean

C#

Boolean stryisactive = Convert.ToBoolean(arrLIst[7]);

/// Not Needed
//                if (stryisactive == "true")
//                {
//                    stryisactive = "1";
//                }
//                else
//                {
//                    stryisactive = "0";
//                }

This should solve your error.

jeyamothi · Answer 4 · 2012-07-12T22:53:00

Solution 3

I think you try to convert the boolean value to string. you can try this line

C#

myCommand.Parameters.AddWithValue("@istaxexempted", parameteristaxexempted);

instead of this line

C#

myCommand.Parameters.Add(parameteristaxexempted).Value.ToString();

Posted 12-Jul-12 22:53pm

jeyamothi

Updated 13-Jul-12 2:45am

v2

Comments

2011999 13-Jul-12 5:13am

not working

2011999 13-Jul-12 6:19am

System.FormatException: String was not recognized as a valid Boolean. Error

jeyamothi 13-Jul-12 6:51am

istaxexpted has a boolean or string

2011999 13-Jul-12 7:10am

string

_Amy · Answer 5 · 2012-07-13T01:21:00

Solution 4

Hi try this:

C#

Boolean stryisactive = Convert.ToBoolean(arrLIst[7]);

And then:

C#

myCommand.Parameters.Add("@istaxexempted", stryisactive);

This will work. Try this.

--Amit

Posted 13-Jul-12 1:21am

_Amy

How to resolve this error

5 solutions

Solution 2

Solution 5

Solution 1

Solution 3

Solution 4

Add your solution here

Preview 0