<div>
I usually add an Extension method to the project and use it like this<br />
<br />
Textbox1.Text = IsStringNull(reader.item(1<wbr />))<br />
TextBox2.Text = IsIntNull(reader.item(2))<br />
<br />
<a href="http://www.codeproject.com/KB/vb/BeginnerExtensionMethods.aspx" rel="ugc">http://www.codeproject.com/KB/vb/BeginnerExtensionMethods.aspx</a><br />
<br />
<a href="http://www.developer.com/net/vb/article.php/3679651/Implementing-Extension-Methods-in-VBNET.htm" rel="ugc">http://www.developer.com/net/vb/article.php/3679651/Implementing-Extension-Methods-in-VBNET.htm</a><br />

</div>


I usually add an Extension method to the project and use it like this

Textbox1.Text = IsStringNull(reader.item(1))
TextBox2.Text = IsIntNull(reader.item(2))

http://www.codeproject.com/KB/vb/BeginnerExtensionMethods.aspx [http://www.codeproject.com/KB/vb/BeginnerExtensionMethods.aspx]

http://www.developer.com/net/vb/article.php/3679651/Implementing-Extension-Methods-in-VBNET.htm [http://www.developer.com/net/vb/article.php/3679651/Implementing-Extension-Methods-in-VBNET.htm]


<div>
in your sql query, you can do this:<br />
select field1, field2, isnull(location, 0) as location from tablename
</div>


in your sql query, you can do this:
select field1, field2, isnull(location, 0) as location from tablename

<div>
You may use:<br />
<br />
IIF(IsDBNull(Expression) and (Not Information.IsNumeric(Expr<wbr />ession)) ,<b> &quot;&nbsp;&quot;</b>, IIF(Information.IsNumeric(<wbr />Expression<wbr />) and IsDBNull(Expression),<b> 0</b> , defaultvalue)<br />
<br />
Also, you can use Coalesce() in SQL which returns first Non-null value.
</div>


You may use:

IIF(IsDBNull(Expression) and (Not Information.IsNumeric(Expression)) , " ", IIF(Information.IsNumeric(Expression) and IsDBNull(Expression), 0 , defaultvalue)

Also, you can use Coalesce() in SQL which returns first Non-null value.

<div>
Thanks. &nbsp;IsNull works fine for what I want.
</div>


Thanks.  IsNull works fine for what I want.

<div>
<div class="content wysiwyg-content">
If believe I've seen this done before, but how do I handle a NULL from a database on this statement: <br />
<br />
Reader.Item(Reader.GetOrdi<wbr />nal(&quot;locat<wbr />ion&quot;))<br />
<br />
I know I could first do: <br />
<br />
If Not IsDBNull(Reader.Item(Reade<wbr />r.GetOrdin<wbr />al(&quot;locati<wbr />on&quot;))) then<br />
<br />
but is there a way on the Reader statement to tell it to convert NULL to a space for text and 0 for numeric? &nbsp;<br />

</div>
</div>


If believe I've seen this done before, but how do I handle a NULL from a database on this statement: 

Reader.Item(Reader.GetOrdinal("location"))

I know I could first do: 

If Not IsDBNull(Reader.Item(Reader.GetOrdinal("location"))) then

but is there a way on the Reader statement to tell it to convert NULL to a space for text and 0 for numeric?  


Checking for NULL

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,