I am using an OledbDataReader to read each record into an array of
objects, as usual.


  My question is:

  is it ever possible that one of the values contained in the array be
Nothing.

  I have never seen it happen and I would believe it is impossible.

 Can anyone confirm that ? And in case what is the reason ?


-P

pamela fluente wrote:


> 
> 
>    I am using an OledbDataReader to read each record into an array of
> objects, as usual.
> 
> 
>   My question is:
> 
>   is it ever possible that one of the values contained in the array be
> Nothing.
> 
>   I have never seen it happen and I would believe it is impossible.
> 
>  Can anyone confirm that ? And in case what is the reason ?
> 
> 
> -P


	It's my understanding that it can't happen, NULL values are always
specified as DBNull.Value.

	In general, use the native ADO.NET providers instead of oledb to be
sure.

		FB

-- 
------------------------------------------------------------------------
Lead developer of LLBLGen Pro, the productive O/R mapper for .NET
LLBLGen Pro website: http://www.llblgen.com
My .NET blog: http://weblogs.asp.net/fbouma
Microsoft MVP (C#) 
------------------------------------------------------------------------

On 12 Lug, 10:22, "Frans Bouma [C# MVP]"
 wrote:


>
>         It's my understanding that it can't happen, NULL values are always
> specified as DBNull.Value.
>
>         In general, use the native ADO.NET providers instead of oledb to be
> sure.
>
>                 FB
>
> --
> ------------------------------------------------------------------------
> Lead developer of LLBLGen Pro, the productive O/R mapper for .NET
> LLBLGen Pro website:http://www.llblgen.com
> My .NET blog:http://weblogs.asp.net/fbouma
> Microsoft MVP (C#)
> ------------------------------------------------------------------------- Nascondi testo tra virgolette -
>
> - Mostra testo tra virgolette -


Thanks Frans,

  I wanted to make sure that programmatically I only need to check for
dbNull values.

  So far I have never neen a Nothing value. But perhaps did not try
hard enough.

  I was wondering if perhaps it is actually impossible for some
technical reason (OleDB implementation).

  I do have seen however an "Object" type (which is somehow curious).
So I was wondering whether it could also
  spit a Nothing value.

  BTW I am considering OleDb (and only that) because I am doing a
cross work among many different platforms.

-P