From: Miro on
Hi,

I have been struggling with this for a long time now and I cant seem to find
a solution.
I have a typed dataset with an int32 column ( that I just added to an access
database ).

So now within the database I have dbnull's in all the old records that did
not have this int32.
So if I read my field I get an exception error.

I put this simple code infront of the code as I have been googling around:
Dim IDNullError As Boolean = False

If ShoppingCartBibCustomRow.IsFrontColorIDNull Then
IDNullError = True
Else
IDNullError = False
End If

but it always returns FALSE - never true.
In the "Immediate Window" for debugging:
? ShoppingCartBibCustomRow.IsFrontColorIDNull
False

but if I look at the value in the Locals tab...
+ FrontNameColorID {"The value for column 'FrontNameColorID' in table
'ShoppingCartBibCustom' is DBNull."} Integer


so If I actaully do this in the "Immediate window",
? ShoppingCartBibCustomRow.FrontNameColorID
ill get the exception:
A first chance exception of type 'System.InvalidCastException' occurred in
Microsoft.VisualBasic.dll
A first chance exception of type 'System.Data.StrongTypingException'
occurred in App_Code.rd6a6lcl.dll

So why does it not return that it is a null value in the first place.

Thank you,

Miro

From: Mr. Arnold on
On 10/4/2010 9:56 PM, Miro wrote:
> Hi,
>
> I have been struggling with this for a long time now and I cant seem to
> find a solution.
> I have a typed dataset with an int32 column ( that I just added to an
> access database ).
>
> So now within the database I have dbnull's in all the old records that
> did not have this int32.
> So if I read my field I get an exception error.
>
> I put this simple code infront of the code as I have been googling around:
> Dim IDNullError As Boolean = False
>
> If ShoppingCartBibCustomRow.IsFrontColorIDNull Then
> IDNullError = True
> Else
> IDNullError = False
> End If
>
> but it always returns FALSE - never true.
> In the "Immediate Window" for debugging:
> ? ShoppingCartBibCustomRow.IsFrontColorIDNull
> False
>
> but if I look at the value in the Locals tab...
> + FrontNameColorID {"The value for column 'FrontNameColorID' in table
> 'ShoppingCartBibCustom' is DBNull."} Integer
>
>
> so If I actaully do this in the "Immediate window",
> ? ShoppingCartBibCustomRow.FrontNameColorID
> ill get the exception:
> A first chance exception of type 'System.InvalidCastException' occurred
> in Microsoft.VisualBasic.dll
> A first chance exception of type 'System.Data.StrongTypingException'
> occurred in App_Code.rd6a6lcl.dll
>
> So why does it not return that it is a null value in the first place.
>
> Thank you,
>
> Miro

I think you're going to need to check the object for being null.

If ShoppingCartBibCustomRow.FrontNameColorID == null.

Everything in .NET is an object. So you should check for something being
an object. It's not an object if it's null.

From: Miro on
The problem is that you cannot.

The second you do anything with this line:
ShoppingCartBibCustomRow.FrontNameColorID
the typed dataset throws an exception.
You cannot change in the typed dataset 'not to' throw an exception.
It only allows you to set the "on Null return empty / null " on strings.

So I would like to check for null - but I cant even check as the exception
comes out.

M.

"Mr. Arnold" <Arnold(a)Arnold.com> wrote in message
news:#DKYt5HZLHA.620(a)TK2MSFTNGP05.phx.gbl...
> On 10/4/2010 9:56 PM, Miro wrote:
>> Hi,
>>
>> I have been struggling with this for a long time now and I cant seem to
>> find a solution.
>> I have a typed dataset with an int32 column ( that I just added to an
>> access database ).
>>
>> So now within the database I have dbnull's in all the old records that
>> did not have this int32.
>> So if I read my field I get an exception error.
>>
>> I put this simple code infront of the code as I have been googling
>> around:
>> Dim IDNullError As Boolean = False
>>
>> If ShoppingCartBibCustomRow.IsFrontColorIDNull Then
>> IDNullError = True
>> Else
>> IDNullError = False
>> End If
>>
>> but it always returns FALSE - never true.
>> In the "Immediate Window" for debugging:
>> ? ShoppingCartBibCustomRow.IsFrontColorIDNull
>> False
>>
>> but if I look at the value in the Locals tab...
>> + FrontNameColorID {"The value for column 'FrontNameColorID' in table
>> 'ShoppingCartBibCustom' is DBNull."} Integer
>>
>>
>> so If I actaully do this in the "Immediate window",
>> ? ShoppingCartBibCustomRow.FrontNameColorID
>> ill get the exception:
>> A first chance exception of type 'System.InvalidCastException' occurred
>> in Microsoft.VisualBasic.dll
>> A first chance exception of type 'System.Data.StrongTypingException'
>> occurred in App_Code.rd6a6lcl.dll
>>
>> So why does it not return that it is a null value in the first place.
>>
>> Thank you,
>>
>> Miro
>
> I think you're going to need to check the object for being null.
>
> If ShoppingCartBibCustomRow.FrontNameColorID == null.
>
> Everything in .NET is an object. So you should check for something being
> an object. It's not an object if it's null.
>
From: Cubaman on
On Oct 5, 3:56 am, "Miro" <m...(a)beero.com> wrote:
> Hi,
>
> I have been struggling with this for a long time now and I cant seem to find
> a solution.
> I have a typed dataset with an int32 column ( that I just added to an access
> database ).
>
> So now within the database I have dbnull's in all the old records that did
> not have this int32.
> So if I read my field I get an exception error.
>
> I put this simple code infront of the code as I have been googling around:
>                 Dim IDNullError As Boolean = False
>
>                 If ShoppingCartBibCustomRow.IsFrontColorIDNull Then
>                     IDNullError = True
>                 Else
>                     IDNullError = False
>                 End If
>
> but it always returns FALSE - never true.
> In the "Immediate Window" for debugging:
> ? ShoppingCartBibCustomRow.IsFrontColorIDNull
> False
>
> but if I look at the value in the Locals tab...
> +               FrontNameColorID        {"The value for column 'FrontNameColorID' in table
> 'ShoppingCartBibCustom' is DBNull."}       Integer
>
> so If I actaully do this in the "Immediate window",
> ? ShoppingCartBibCustomRow.FrontNameColorID
> ill get the exception:
> A first chance exception of type 'System.InvalidCastException' occurred in
> Microsoft.VisualBasic.dll
> A first chance exception of type 'System.Data.StrongTypingException'
> occurred in App_Code.rd6a6lcl.dll
>
> So why does it not return that it is a null value in the first place.
>
> Thank you,
>
> Miro
The DBNull type is a singleton class, which means only one DBNull
object exists. The DBNull.Value member represents the sole DBNull
object. DBNull.Value can be used to explicitly assign a nonexistent
value to a database field, although most ADO.NET data providers
automatically assign values of DBNull when a field does not have a
valid value. You can determine whether a value retrieved from a
database field is a DBNull value by passing the value of that field to
the DBNull.Value.Equals method. However, some languages and database
objects supply methods that make it easier to determine whether the
value of a database field is DBNull.Value. These include the Visual
Basic IsDBNull function, the Convert.IsDBNull method, the
DataTableReader.IsDBNull method, and the IDataRecord.IsDBNull method.

Do not confuse the notion of null in an object-oriented programming
language with a DBNull object. In an object-oriented programming
language, null means the absence of a reference to an object. DBNull
represents an uninitialized variant or nonexistent database column.

http://msdn.microsoft.com/en-us/library/system.dbnull.aspx

Best regards
From: Jason Keats on
Miro wrote:
>
> The second you do anything with this line:
> ShoppingCartBibCustomRow.FrontNameColorID
> the typed dataset throws an exception.
> You cannot change in the typed dataset 'not to' throw an exception.
> It only allows you to set the "on Null return empty / null " on strings.
>
> So I would like to check for null - but I cant even check as the
> exception comes out.
>

Doesn't every nullable column in a typed dataset have an
Is[ColumnName]Null() method?

Alternatively, you can annotate your XSD using the nullValue attribute...

http://ondotnet.com/pub/a/dotnet/2003/03/31/typeddatasetannotations.html