.net dbnull.value sqlparameter where

Question

I have a probleme with a sql query :

I would like do something like :

SELECT * FROM myTable WHERE [myBoolField] IS NULL

if i run this query, i have my results,

but i would like use parameters, so i add :

SELECT * FROM myTable WHERE [myBitField] IS @myBitField

with

New SqlParameter("@myBitField", dbnull.value)

i have an error at the @myBoolField

if i pass a value like true or false, that's work ( with " = @myBitField")

Can someone help me ?

Thanks

Sami Kuhmonen · Accepted Answer · 2015-07-30 10:17:55Z

1

You can only test for NULL using IS NULL. You cannot use parameters and there wouldn't really be any point.

DBNull.Value can be used when inserting or comparing values in code, but not on WHERE conditions since NULL is not equal to even another NULL.

answered Jul 30, 2015 at 10:17

Sami Kuhmonen

31.4k9 gold badges67 silver badges81 bronze badges

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

2 Comments

Testman Over a year ago

oh... okay, but dbnull.value is NULL, so it's strange, no ? And as you said you can use it for insert for example

Sami Kuhmonen Over a year ago

@Testman when using parameters the query is usually parsed beforehand and the parameters are not just substituted into the string. The parser will see IS @parameter and say "nope, that's not acceptable" and that's it.

Collectives™ on Stack Overflow

.net dbnull.value sqlparameter where

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related