<div>
You may always compare the value of a field with DbNull.Value:<br />
if dr(&quot;Field&quot;) = DBNull.Value then<br />
&nbsp; &nbsp;do something<br />
end if<br />
<br />
sorry for the syntax, I'm not a VB guy. DBNull.Value is defined in .NET.
</div>


You may always compare the value of a field with DbNull.Value:
if dr("Field") = DBNull.Value then
   do something
end if

sorry for the syntax, I'm not a VB guy. DBNull.Value is defined in .NET.

<div>
Copied from Anthony's question....<br />
<br />
&quot;I dont want to do test &quot;if if not isnull(&quot;field&quot;) then form control = field value&quot;&quot;
</div>


Copied from Anthony's question....

"I dont want to do test "if if not isnull("field") then form control = field value""

<div>
<div class="content wysiwyg-content">
Does vb.net have a direct function that deals with nulls, When i am loading values from a database to a form, when one field is null, i get the error massage can't convert dbnull to string, I dont want to do test &quot;if if not isnull(&quot;field&quot;) then form control = field value&quot;. for example access had a function (NZ) that could automatically convert nulls to empty strings or 0.<br />
<br />
ANTHONY MATOVU<br />

</div>
</div>


Does vb.net have a direct function that deals with nulls, When i am loading values from a database to a form, when one field is null, i get the error massage can't convert dbnull to string, I dont want to do test "if if not isnull("field") then form control = field value". for example access had a function (NZ) that could automatically convert nulls to empty strings or 0.

ANTHONY MATOVU


dealing with null value.

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.