Error while passing DBNull to SqlParameter

Question

I am trying to pass null value to SqlParameter if the value of variable vName is null, else pass vName value as shown below

cmd.Parameters.Add(new SqlParameter("@NAME", SqlDbType.VarChar)).Value = vName ? null : DBNull.Value;

but I get an error

Cannot implicitly convert type 'string' to 'bool'

I searched and found that I have to use AgeItem.AgeIndex but I got error that says

The name 'AgeItem' does not exist in the current context

cmd.Parameters.Add(new SqlParameter("@NAME", SqlDbType.VarChar)).Value =(object)AgeItem.AgeIndex ?? DBNull.Value;

md.Parameters.Add(new SqlParameter("@NAME", SqlDbType.VarChar)).Value = vName ? vName : DBNull.Value; is it a spelling mistake? u didnt pass vname — Naruto
– Naruto, Commented Oct 8, 2018 at 15:14

Tim Schmelter · Accepted Answer · 2018-10-08 15:15:27Z

3

vName is a string but you use it like it was a bool: vName ? .... Use vName == null ? ...:

cmd.Parameters.Add(new SqlParameter("@NAME", SqlDbType.VarChar)).Value =
     vName == null ? DBNull.Value : (Object)vName;

answered Oct 8, 2018 at 15:15

Tim Schmelter

462k79 gold badges719 silver badges980 bronze badges

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

Comments

John · Accepted Answer · 2018-10-08 20:10:12Z

1

IMHO much cleaner:

if (vName != null)
    cmd.Parameters.AddWithValue("@NAME",vName);
else
    cmd.Parameters.AddWithValue("@Name",null);

answered Oct 8, 2018 at 20:10

John

8391 gold badge10 silver badges22 bronze badges

PS. If the command is a Stored Procedure and can accept a null value then the else and subsequent lines are not necessary.

Malitha Shan · Accepted Answer · 2018-10-08 15:16:46Z

0

Code should be change as follow

cmd.Parameters.Add(new SqlParameter("@NAME", SqlDbType.VarChar)).Value!= null ? vName: DBNull.Value;

answered Oct 8, 2018 at 15:16

Malitha Shan

211 silver badge3 bronze badges

error -> Type of conditional expression cannot be determined because there is no implicit conversion between 'string' and 'System.DBNull'