How to potentially pass null in as a parameter in ADO.Net

Question

I'm trying to pass a parameter into a stored proc using ADO.NET. This paramater is of type int but the field in the database is nullable. Here's my code:

AddInParameter(cmd, "@i_Required_License_List_PKID", DbType.Int32, RequiredLicenseListPkid==""? null : Convert.ToInt32(RequiredLicenseListPkid);

When I do this I get an error saying that there's no conversion between null and int.

I have also tried DbNull.Value in place of null but with the same result.

I can't seem to find any nullable parameter types in the DbType class but I wonder is that the solution.

Shaul Zuarets · Accepted Answer · 2014-06-30 13:34:57Z

2

Use: DBNull.Value;

as the value of the parameter

answered Jun 30, 2014 at 13:34

Shaul Zuarets

8492 gold badges10 silver badges21 bronze badges

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

Comments

Wiki · Accepted Answer · 2014-06-30 15:06:32Z

AddInParameter(cmd, "@i_Required_License_List_PKID", DbType.Int32, RequiredLicenseListPkid==""? DBNull.Value: Convert.ToInt32(RequiredLicenseListPkid);

Collectives™ on Stack Overflow

How to potentially pass null in as a parameter in ADO.Net

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Linked

Related