<div>
Sounds like what you really want to do is have a COALESCE statement in the sql used to create the reader, to that a NULL value is never returned in the first place.
</div>


Sounds like what you really want to do is have a COALESCE statement in the sql used to create the reader, to that a NULL value is never returned in the first place.

<div>
hi jcoehoorn,<br />
<br />
I have done this already. I am just making sure that there is no way this thing is going to fall over in a nasty way.
</div>


hi jcoehoorn,

I have done this already. I am just making sure that there is no way this thing is going to fall over in a nasty way.

<div>
<div class="content wysiwyg-content">
Hi There,<br />
<br />
What's the syntax for testing for sqldatareader ordinals for null?I tried something like below but it's not working.<br />
<br />
Sean <br />
<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;class.propertyname = reader.GetOrdinal(&quot;myID&quot;)=<wbr />= DBNull.Value ? 0 : reader.GetInt32(reader.Get<wbr />Ordinal(&quot;m<wbr />yID&quot;));<br />
<br />
<br />
<br />

</div>
</div>


Hi There,

What's the syntax for testing for sqldatareader ordinals for null?I tried something like below but it's not working.

Sean 


           class.propertyname = reader.GetOrdinal("myID")== DBNull.Value ? 0 : reader.GetInt32(reader.GetOrdinal("myID"));





checking for dbnull values - sqldatareader ordinals

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.