How whould I structure a DBNull statement in a single line???

[Aaron Ackerman]

I want to be able to do the following in a single line.

newDataSetRow.AdditionalHours = if
IsDBNull(vdsPublisherLocal.Tables("CaseInstance"). Rows(i).Item("AdditionalHo
urs")) then 0 end if

if the value is null I want to put a valid value in place of the dataset
field, how can i do this?

[Cor]

Hi Aaron,

You can using the IIf function, but I find that so bad, that I do not want
to take any time in it.

But if you want to use it, feel free, you just can find is searching for IIf
in MSDN

Cor

newDataSetRow.AdditionalHours = if
IsDBNull(vdsPublisherLocal.Tables("CaseInstance"). Rows(i).Item("AdditionalHo urs")) then 0 end if if the value is null I want to put a valid value in place of the dataset
field, how can i do this?

[Armin Zingler]

"Aaron Ackerman" <[e-mail]> schrieb

I want to be able to do the following in a single line.

newDataSetRow.AdditionalHours = if
IsDBNull(vdsPublisherLocal.Tables("CaseInstance"). Rows(i).Item("AdditionalHo urs")) then 0 end if

if the value is null I want to put a valid value in place of the
dataset field, how can i do this?

if isdbnull(vdsPublisherLocal.Tables( _
"CaseInstance").Rows(i).Item("AdditionalHours" ))) then

newDataSetRow.AdditionalHours = 0
end if

Instead of using isdbnull you can compare against DBNull.Value.

--
Armin

http://www.plig.net/nnq/nquote.html
http://www.netmeister.org/news/learn2quote.html

[Herfried K. Wagner [MVP]]

* "Aaron Ackerman" <[e-mail]> scripsit:

I want to be able to do the following in a single line.

newDataSetRow.AdditionalHours = if
IsDBNull(vdsPublisherLocal.Tables("CaseInstance"). Rows(i).Item("AdditionalHo
urs")) then 0 end if

\\\
If ... Then newDataSetRow.AdditionalHours = 0
///

--
Herfried K. Wagner [MVP]
<http://www.mvps.org/dotnet>

[Phill. W]

"Aaron Ackerman" <[e-mail]> wrote in message
news:e0**************@TK2MSFTNGP11.phx.gbl...

newDataSetRow.AdditionalHours = if
IsDBNull(vdsPublisherLocal.Tables("CaseInstance"). Rows(i).Item("AdditionalHo
urs")) then 0 end if
.. . . if the value is null I want to put a valid value in place of the dataset
field, how can i do this?

Like this:

newDataSetRow.AdditionalHours _
= IIf( 'LongFieldName' <> DBNull.Value _
, 'LongFieldName' _
, 0 _
)

HTH,
Phill W.