Insert Null value to the Integer Column

Question

Through the front end I want to insert NULL value to the Column whose DataType is Int.

I used like this:

POP.JobOrderID = Convert.ToInt32(DBNull.Value);

But I cannot Insert Null value, it throws error such as "Object cannot be cast from DBNull to other types":

How to insert NULL values?

abatishchev · Accepted Answer · 2011-06-25 19:41:11Z

8

if you wish to do it POP.JobOrderID should be type int? (nullable int) not int

edited Jun 25, 2011 at 19:41

abatishchev

101k88 gold badges303 silver badges443 bronze badges

answered Jun 25, 2011 at 14:32

kleinohad

5,9202 gold badges29 silver badges35 bronze badges

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

2 Comments

thevan Over a year ago

POP is an Object and JobOrderID is an Int. How to assign like this?

thevan Over a year ago

I am using three tier architecture. I would pass parameter like above what i had given in the Question. How to apply int?(nullable) in this?

Jonas Høgh · Accepted Answer · 2011-06-25 14:35:37Z

5

kleinohad is correct. Furthermore, you should assign null, not DBNull.Value

answered Jun 25, 2011 at 14:35

Jonas Høgh

10.9k1 gold badge29 silver badges49 bronze badges

1 Comment

thevan Over a year ago

I am using three tier architecture. I would pass parameter like above what i had given in the Question. How to apply int?(nullable) in this?

abatishchev · Accepted Answer · 2011-06-25 19:42:16Z

4

Use Nullable<Int32> or just an alias: int?.

POP.JobOrderID = 5;
// or
POP.JobOrderID = null;

Usage in ADO.NET:

command.Parameters.AddWithValue("@JobOrderId", POP.JobOrderID ?? DBNull.Value);

which is equals to:

POP.JobOrderID.HasValue ? POP.JobOrderID.Value : DBNull.Value;

edited Jun 25, 2011 at 19:42

answered Jun 25, 2011 at 19:36

abatishchev

101k88 gold badges303 silver badges443 bronze badges

Comments

axel22 · Accepted Answer · 2011-06-25 23:24:41Z

2

This

   POP.JobOrderID = new Nullable<Int32>();

should work too IF the JobOrderID is a nullable type (int?).

Cheers

edited Jun 25, 2011 at 23:24

axel22

32.4k10 gold badges127 silver badges139 bronze badges

answered Jun 25, 2011 at 19:32

Jaime

1721 silver badge7 bronze badges

Comments

Ken D · Accepted Answer · 2011-06-25 14:43:38Z

0

Like this:

 POP.JobOrderID = null;    // JobOrderID should be of type int? which is a nullable-int

Hope that helps.

answered Jun 25, 2011 at 14:43

Ken D

5,9882 gold badges40 silver badges58 bronze badges

Collectives™ on Stack Overflow

Insert Null value to the Integer Column

5 Answers 5

2 Comments

1 Comment

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

2 Comments

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related