<div>
You need to check for DBNull before you attempt to assign to a variable.<br />
<br />
e.g.<br />
<br />

<pre><code id="code-20-40189321-1">Dim defaultValue As Integer = -1
Dim x As Integer = If(dbReader(&quot;column&quot;) &lt;&gt; DBNull.Value, dbReader(&quot;column&quot;), defaultValue)</code></pre>
</div>


You need to check for DBNull before you attempt to assign to a variable.

e.g.



Dim defaultValue As Integer = -1
Dim x As Integer = If(dbReader("column") <> DBNull.Value, dbReader("column"), defaultValue)

<div>
Ok...this is what I had!<br />
<br />

<pre><code id="code-20-40189340-1">clsDE.rangeUnitType_ID = If (row(&quot;unitType_ID&quot;).ToString.Length = 0, DBNull.Value, row(&quot;unitType_ID&quot;))</code></pre>
</div>


Ok...this is what I had!



clsDE.rangeUnitType_ID = If (row("unitType_ID").ToString.Length = 0, DBNull.Value, row("unitType_ID"))

<div>
Ok,<br />
<br />
I just got the following error on the below line of code (see attached image).<br />
<br />

<pre><code id="code-20-40189366-1">        clsDE.serialNO = If(row.Cells(3).Value &lt;&gt; DBNull.Value, row.Cells(3).Value, &quot;&quot;)</code></pre>
<a href="https://filedb.experts-exchange.com/incoming/2014/07_w28/860130/Screenshot.jpg" target="_blank" class="file-inline" title="Screen shot of Error (47 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>Screenshot.jpg</a>
</div>


Ok,

I just got the following error on the below line of code (see attached image).



        clsDE.serialNO = If(row.Cells(3).Value <> DBNull.Value, row.Cells(3).Value, "")

Screenshot.jpg [https://filedb.experts-exchange.com/incoming/2014/07_w28/860130/Screenshot.jpg]

Screenshot.jpg

<div>
Thanks Fernando...that worked!
</div>


<div>
Not a problem BlakeMcKenna, glad to help.
</div>


Not a problem BlakeMcKenna, glad to help.

<div>
<div class="content wysiwyg-content">
I know this is an elementary question but I still get stuck on it and do it inadvertently at times, but when retrieving values from a database result set, how do you prevent a NULL Value Error. For example, if a Database Field is defined as a numeric but contains nothing, it will return a NULL value. How can I prevent an exception from happening. Because currently I'm getting the following error: <br />
<br />
&quot;Conversion from type 'DBNull' to type 'Integer' is not valid&quot;
</div>
</div>


I know this is an elementary question but I still get stuck on it and do it inadvertently at times, but when retrieving values from a database result set, how do you prevent a NULL Value Error. For example, if a Database Field is defined as a numeric but contains nothing, it will return a NULL value. How can I prevent an exception from happening. Because currently I'm getting the following error: 

"Conversion from type 'DBNull' to type 'Integer' is not valid"

Checking for NULL Value?

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,