How to deal with DBNull's

[Mr Newbie]

Hi,

I have a strongly typed dataset and when I am trying to process this, one
field is empty ( which is correct at this stage ), but I need to test to see
if it has a value before I try and assign it otherwise it throws an
exception, I have tried the following and a few variations but cant work out
how to test this, any ideas ?

If expRow.DateAuthorised = Nothing Then
Me.AuthorisedDate.Text = expRow.DateAuthorised.Date.ToString

End If

[Jon]

IsDBNull(field) is how to test for nulls

"If foo is nothing" will not work.
"Mr Newbie" <he**@now.com> wrote in message
news:eW**************@TK2MSFTNGP11.phx.gbl...

Hi,

I have a strongly typed dataset and when I am trying to process this, one
field is empty ( which is correct at this stage ), but I need to test to
see if it has a value before I try and assign it otherwise it throws an
exception, I have tried the following and a few variations but cant work
out how to test this, any ideas ?

If expRow.DateAuthorised = Nothing Then
Me.AuthorisedDate.Text = expRow.DateAuthorised.Date.ToString

End If

[Herfried K. Wagner [MVP]]

"Mr Newbie" <he**@now.com> schrieb:

I have a strongly typed dataset and when I am trying to process this, one
field is empty ( which is correct at this stage ), but I need to test to
see if it has a value before I try and assign it otherwise it throws an
exception, I have tried the following and a few variations but cant work
out how to test this, any ideas ?

If expRow.DateAuthorised = Nothing Then
Me.AuthorisedDate.Text = expRow.DateAuthorised.Date.ToString

\\\
If IsDBNull(expRow.DateAuthorized) Then
Me.AutorizedDate.Text = expRow.DateAuthorized.Date.ToString()
End If
///

Alternatively you can use 'If expRow.DateAuthorized Is DBNull.Value
Then...'.

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://classicvb.org/petition/>

[Bart Mermuys]

Hi,

"Mr Newbie" <he**@now.com> wrote in message
news:eW**************@TK2MSFTNGP11.phx.gbl...

Hi,

I have a strongly typed dataset and when I am trying to process this, one
field is empty ( which is correct at this stage ), but I need to test to
see if it has a value before I try and assign it otherwise it throws an
exception, I have tried the following and a few variations but cant work
out how to test this, any ideas ?

If expRow.DateAuthorised = Nothing Then
If you use a Typed DataSet and assuming that DateAuthorised can be null,
then you will also have the following functions :
expRow.IsDataAuthorisedNull()
expRow.SetDateAuthorisedNull()

So, you need to do:

If ( Not expRow.IsDateAuthorisedNull() ) Then
Me.AuthorisedDate.Text = expRow.DateAuthorised.Date.ToString
End If

Accessing the property when it's DBNull.Value results in an Exception,
because the poperty-get tries to cast the DBNull.Value into a DateTime which
can't be done.

HTH,
Greetings

Me.AuthorisedDate.Text = expRow.DateAuthorised.Date.ToString

End If

[Cor Ligthert [MVP]]

Mr Newbie,

I don't know why however I use forever

If Not ExpRow.DataAuthorised Is DbNull.Value then

Just as alternative

Cor