How To Make a Nullable Integer Value

Question

I'm just start to make an application. I got some textfield that must filled with integer value, but when the textfield is empty, I want the value is still null in database rather than must add "0".

it's something like this

        DR.IN = Me.txtIn.Text
        DR.OUT = Me.txtOut.Text

the two of that is integer value, that when i'm save to data base the error comes and said

The Nullable Object Must Have Value

I must add "0", but I want the data is still null. Do anyone know how to do that?

thanks for your help and sorry for really bad grammar, I hope someone out there would understand my question :)

Me.txtIn.Text != nothing then Me.txtIn.Text else nothing.But make sure DR.IN and DR.OUT are nullable ints.Something like Dim DR.IN? as int — Amit Kumar Ghosh
– Amit Kumar Ghosh, Commented Sep 23, 2015 at 7:46
@AmitKumarGhosh uumm.. I'm not sure I understand that, sorry — JTR
– JTR, Commented Sep 23, 2015 at 7:54

Matt Wilko · Accepted Answer · 2015-09-23 07:43:42Z

3

You can just do a conditional check using the If Operator to return either Nothing (null) if there is no text in the textbox or the integer value of the textbox:

Dim value As Integer? = If(TextBox1.Text.Length = 0, Nothing, Integer.Parse(TextBox1.Text))

answered Sep 23, 2015 at 7:43

Matt Wilko

27.4k10 gold badges99 silver badges146 bronze badges

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

1 Comment

JTR Over a year ago

hey, yeah! this is all I need. Thank's so much!

jmcilhinney · Accepted Answer · 2015-09-23 07:45:41Z

0

You haven't shown some rather important information but I'm going to assume that you are using the Value property of your Integer? without first checking whether it actually has a value. That's the whole point of a Nullable: it can have a value or not. You can't use the value if there isn't one. Saving an Integer? might look like this:

Dim command as new SqlCommand

command.CommandText = "UPDATE MyTable SET Number = @Number WHERE ID = @ID"

command.Parameters.Add("@Number", SqlDbType.Int).Value = If(myNullableInteger.HasValue,
                                                            myNullableInteger.Value,
                                                            CObj(DBNull.Value))

answered Sep 23, 2015 at 7:45

jmcilhinney

54.9k5 gold badges30 silver badges52 bronze badges

Comments

Joehl · Accepted Answer · 2015-09-23 11:23:43Z

0

You can make a nullable integer in C# like :

int? myint;

and in VB.net like:

Dim myint As Integer?

edited Sep 23, 2015 at 11:23

Joehl

3,7013 gold badges27 silver badges55 bronze badges

answered Sep 23, 2015 at 11:12

Kartik Chandra Biswas

13 bronze badges

Comments

xum59 · Accepted Answer · 2015-09-23 07:45:43Z

-1

Using default(Nullable<type>) will return you a Nullable<type> set to null.

answered Sep 23, 2015 at 7:45

xum59

8519 silver badges16 bronze badges

2 Comments

xum59 Over a year ago

My bad... Question was flagged C# initially. I'm no VB.Net expert :$

JTR Over a year ago

that's okay, also my bad to add C# tag, that I don't even remember I've add that tag xD

Collectives™ on Stack Overflow

How To Make a Nullable Integer Value

4 Answers 4

1 Comment

Comments

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related