Getting SQL Error: Failed to convert parameter value from a String to a Boolean.1

Question

Using Asp.Net (C#) I'm submitting the following value to a field in the DB:

//Adding to parameters (for stored proc)
command.Parameters.Add( "MyField", SqlDbType.Bit, 1 ).Value = "1";

How do I fix this issue? What am I doing wrong?

D'Arcy Rittich · Accepted Answer · 2013-02-01 01:12:34Z

2

According to MSDN, SqlDbType.Bit is:

An unsigned numeric value that can be 0, 1, or null.

So, try:

command.Parameters.Add( "MyField", SqlDbType.Bit, 1 ).Value = 1;

answered Feb 1, 2013 at 1:12

D'Arcy Rittich

172k41 gold badges298 silver badges287 bronze badges

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

Comments

Gino4nx · Accepted Answer · 2013-03-19 10:34:40Z

-1

cmd.Parameters.Add("MyField", SqlDbType.Bit).Value = true;

answered Mar 19, 2013 at 10:34

Gino4nx

441 silver badge3 bronze badges