Error msg: Failed to convert parameter value from a String to a Boolean

Question

I am getting an error msg when attempting to update a record from asp.net into a SQL database. The only boolean value being updated is:

cmdAddUser.Parameters.Add(new SqlParameter("@Active", SqlDbType.Bit));
cmdAddUser.Parameters["@Active"].Value = 
    Convert.ToBoolean(cbAddUserActiveUser.Checked);

The datatype for @Active in the database is "bit". Any ideas?

@user279521: You aren't really indicating what error you are getting. Try posting the exception information that you are getting so we can determine if it is a parse issue (on the call to ToBoolean) or something on the database side. — casperOne
– casperOne, Commented Jun 28, 2010 at 15:55
"Failed to convert parameter value from a String to a Boolean." is the error message. — user279521
– user279521, Commented Jun 28, 2010 at 15:56
Wild guess, but try Convert.ToBoolean(cbAddUserActiveUser.Checked.ToString()); — Jason Evans
– Jason Evans, Commented Jun 28, 2010 at 15:58
What about trying without the convert.toboolean? Isn't .checked already a boolean value? — Tommy
– Tommy, Commented Jun 28, 2010 at 16:04

harriyott · Accepted Answer · 2010-06-28 16:06:06Z

2

Long shot - have you got another parameter that is set as a string but is a bit column in the actual table?

answered Jun 28, 2010 at 16:06

harriyott

10.7k10 gold badges69 silver badges104 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user279521 Over a year ago

Good answer. I am modifying this proc that has about 24 paramters.

Collectives™ on Stack Overflow

Error msg: Failed to convert parameter value from a String to a Boolean

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related