C# || operator to VB

[hansiman]

on http://www.bsdg.org/2005/01/empty-dataset.shtml
I came across this C# code:

bool Result = ( aDataset == null ) || ( aDataset.Tables.Count == 0 );

I think I know what it is supposed to do!
How is this coded in VB

[Ken Cox [Microsoft MVP]]

Looks like a logical OR to me...

Dim Result As Boolean = (aDataset Is Nothing) Or (aDataset.Tables.Count = 0)

Sets Result to true if aDataset is Nothing or if there are zero tables in
aDataset
Sets Result to false if aDataset has been initialized or if it has at least
one table.

"hansiman" <ha***@hotmail.com> wrote in message
news:7k********************************@4ax.com...

on http://www.bsdg.org/2005/01/empty-dataset.shtml
I came across this C# code:

bool Result = ( aDataset == null ) || ( aDataset.Tables.Count == 0 );

I think I know what it is supposed to do!
How is this coded in VB

[Steve C. Orr [MVP, MCSD]]

Actually Ken that's not quite right. Your code would fail if aDataSet is
Nothing because both clauses are evaluated and nothing cannot be evaluated.
The more precise transation would be to use the OrElse statment, which short
circuits if aDataSet is nothing, therefore the second clause would not be
evaluated and there would be no error.

Dim Result as Boolean = IsNull(aDataSet) OrElse (aDataSet.Tables.Count = 0)

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://SteveOrr.net
"Ken Cox [Microsoft MVP]" <BA************@sympatico.ca> wrote in message
news:Oe**************@tk2msftngp13.phx.gbl...

Looks like a logical OR to me...

Dim Result As Boolean = (aDataset Is Nothing) Or (aDataset.Tables.Count =
0)

Sets Result to true if aDataset is Nothing or if there are zero tables in
aDataset
Sets Result to false if aDataset has been initialized or if it has at
least one table.

"hansiman" <ha***@hotmail.com> wrote in message
news:7k********************************@4ax.com...

on http://www.bsdg.org/2005/01/empty-dataset.shtml
I came across this C# code:

bool Result = ( aDataset == null ) || ( aDataset.Tables.Count == 0 );

I think I know what it is supposed to do!
How is this coded in VB

[Karl Seguin]

Actually, it's an OrElse as it's short-circuit

You should always be using OrElse when doing logical comparisons instead of
Or...or should only be used as a bit operator..

Karl

--
MY ASP.Net tutorials
http://www.openmymind.net/
"Ken Cox [Microsoft MVP]" <BA************@sympatico.ca> wrote in message
news:Oe**************@tk2msftngp13.phx.gbl...

Looks like a logical OR to me...

Dim Result As Boolean = (aDataset Is Nothing) Or (aDataset.Tables.Count = 0)
Sets Result to true if aDataset is Nothing or if there are zero tables in
aDataset
Sets Result to false if aDataset has been initialized or if it has at least one table.

"hansiman" <ha***@hotmail.com> wrote in message
news:7k********************************@4ax.com...

on http://www.bsdg.org/2005/01/empty-dataset.shtml
I came across this C# code:

bool Result = ( aDataset == null ) || ( aDataset.Tables.Count == 0 );

I think I know what it is supposed to do!
How is this coded in VB

[hansiman]

thanks a lot :-)

Ehhh. I'm using IsDbNull not IsNull - seem to work.

NB I enjoy your aspnetpro column.

On Mon, 7 Feb 2005 14:57:46 -0800, "Steve C. Orr [MVP, MCSD]"
<St***@Orr.net> wrote:

Actually Ken that's not quite right. Your code would fail if aDataSet is
Nothing because both clauses are evaluated and nothing cannot be evaluated.
The more precise transation would be to use the OrElse statment, which short
circuits if aDataSet is nothing, therefore the second clause would not be
evaluated and there would be no error.

Dim Result as Boolean = IsNull(aDataSet) OrElse (aDataSet.Tables.Count = 0)

[Ken Cox [Microsoft MVP]]

Ha!

I should have known better than to hazard a response about C#! Thanks Steve
for setting it straight.

Ken

"Steve C. Orr [MVP, MCSD]" <St***@Orr.net> wrote in message
news:%2****************@TK2MSFTNGP15.phx.gbl...

Actually Ken that's not quite right. Your code would fail if aDataSet is
Nothing because both clauses are evaluated and nothing cannot be
evaluated. The more precise transation would be to use the OrElse
statment, which short circuits if aDataSet is nothing, therefore the
second clause would not be evaluated and there would be no error.

Dim Result as Boolean = IsNull(aDataSet) OrElse (aDataSet.Tables.Count =
0)

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://SteveOrr.net
"Ken Cox [Microsoft MVP]" <BA************@sympatico.ca> wrote in message
news:Oe**************@tk2msftngp13.phx.gbl...

Looks like a logical OR to me...

Dim Result As Boolean = (aDataset Is Nothing) Or (aDataset.Tables.Count =
0)

Sets Result to true if aDataset is Nothing or if there are zero tables in
aDataset
Sets Result to false if aDataset has been initialized or if it has at
least one table.

"hansiman" <ha***@hotmail.com> wrote in message
news:7k********************************@4ax.com...

on http://www.bsdg.org/2005/01/empty-dataset.shtml
I came across this C# code:

bool Result = ( aDataset == null ) || ( aDataset.Tables.Count == 0 );

I think I know what it is supposed to do!
How is this coded in VB

[Ken Cox [Microsoft MVP]]

Thanks Karl! From now on I'll leave the C# questions to the guys who know
it! <grin>
"Karl Seguin" <karl REMOVE @ REMOVE openmymind REMOVEMETOO . ANDME net>
wrote in message news:%2****************@TK2MSFTNGP12.phx.gbl...

Actually, it's an OrElse as it's short-circuit

You should always be using OrElse when doing logical comparisons instead
of
Or...or should only be used as a bit operator..

Karl

--
MY ASP.Net tutorials
http://www.openmymind.net/
"Ken Cox [Microsoft MVP]" <BA************@sympatico.ca> wrote in message
news:Oe**************@tk2msftngp13.phx.gbl...

Looks like a logical OR to me...

Dim Result As Boolean = (aDataset Is Nothing) Or (aDataset.Tables.Count =

0)

Sets Result to true if aDataset is Nothing or if there are zero tables in
aDataset
Sets Result to false if aDataset has been initialized or if it has at

least

one table.

"hansiman" <ha***@hotmail.com> wrote in message
news:7k********************************@4ax.com...

> on http://www.bsdg.org/2005/01/empty-dataset.shtml
> I came across this C# code:
>
> bool Result = ( aDataset == null ) || ( aDataset.Tables.Count == 0 );
>
> I think I know what it is supposed to do!
> How is this coded in VB
>

[Kevin Spencer]

Well, there IS one other exception to that rule, Karl. If you have a
specific reason for needing to evaluate BOTH experssions (such as function
calls that return booleans, but must be made), you should also use the Or
operator.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Neither a follower nor a lender be.

"Karl Seguin" <karl REMOVE @ REMOVE openmymind REMOVEMETOO . ANDME net>
wrote in message news:%2****************@TK2MSFTNGP12.phx.gbl...

Actually, it's an OrElse as it's short-circuit

You should always be using OrElse when doing logical comparisons instead
of
Or...or should only be used as a bit operator..

Karl

--
MY ASP.Net tutorials
http://www.openmymind.net/
"Ken Cox [Microsoft MVP]" <BA************@sympatico.ca> wrote in message
news:Oe**************@tk2msftngp13.phx.gbl...

Looks like a logical OR to me...

Dim Result As Boolean = (aDataset Is Nothing) Or (aDataset.Tables.Count =

0)

Sets Result to true if aDataset is Nothing or if there are zero tables in
aDataset
Sets Result to false if aDataset has been initialized or if it has at

least

one table.

"hansiman" <ha***@hotmail.com> wrote in message
news:7k********************************@4ax.com...

> on http://www.bsdg.org/2005/01/empty-dataset.shtml
> I came across this C# code:
>
> bool Result = ( aDataset == null ) || ( aDataset.Tables.Count == 0 );
>
> I think I know what it is supposed to do!
> How is this coded in VB
>

[Karl Seguin]

Kevin:
My personal opinion is that this leads to
hard-to-read-gonna-cause-problems-down-the-road code. Far better to nest
the if statement in those rare instances. But ur right..it could be used
for that.

Karl
--
MY ASP.Net tutorials
http://www.openmymind.net/
"Kevin Spencer" <ke***@DIESPAMMERSDIEtakempis.com> wrote in message
news:uH*************@TK2MSFTNGP12.phx.gbl...

Well, there IS one other exception to that rule, Karl. If you have a
specific reason for needing to evaluate BOTH experssions (such as function
calls that return booleans, but must be made), you should also use the Or
operator.

--
HTH,

Kevin Spencer
Microsoft MVP
.Net Developer
Neither a follower nor a lender be.

"Karl Seguin" <karl REMOVE @ REMOVE openmymind REMOVEMETOO . ANDME net>
wrote in message news:%2****************@TK2MSFTNGP12.phx.gbl...

Actually, it's an OrElse as it's short-circuit

You should always be using OrElse when doing logical comparisons instead
of
Or...or should only be used as a bit operator..

Karl

--
MY ASP.Net tutorials
http://www.openmymind.net/
"Ken Cox [Microsoft MVP]" <BA************@sympatico.ca> wrote in message
news:Oe**************@tk2msftngp13.phx.gbl...

Looks like a logical OR to me...

Dim Result As Boolean = (aDataset Is Nothing) Or (aDataset.Tables.Count =

0)

Sets Result to true if aDataset is Nothing or if there are zero tables

in aDataset
Sets Result to false if aDataset has been initialized or if it has at

least

one table.

"hansiman" <ha***@hotmail.com> wrote in message
news:7k********************************@4ax.com...
> on http://www.bsdg.org/2005/01/empty-dataset.shtml
> I came across this C# code:
>
> bool Result = ( aDataset == null ) || ( aDataset.Tables.Count == 0 );
>
> I think I know what it is supposed to do!
> How is this coded in VB
>

[Steve C. Orr [MVP, MCSD]]

I agree this leads to hard-to-read code that is prone to errors, and
therefore should be avoided.
This was the argument for having Or function like OrElse does (so that
OrElse wouldn't be necessary) but that battle was lost.
:-(

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://SteveOrr.net
"Karl Seguin" <karl REMOVE @ REMOVE openmymind REMOVEMETOO . ANDME net>
wrote in message news:uM**************@TK2MSFTNGP12.phx.gbl...

Kevin:
My personal opinion is that this leads to
hard-to-read-gonna-cause-problems-down-the-road code. Far better to nest
the if statement in those rare instances. But ur right..it could be used
for that.

Karl
--
MY ASP.Net tutorials
http://www.openmymind.net/
"Kevin Spencer" <ke***@DIESPAMMERSDIEtakempis.com> wrote in message
news:uH*************@TK2MSFTNGP12.phx.gbl...

Well, there IS one other exception to that rule, Karl. If you have a
specific reason for needing to evaluate BOTH experssions (such as
function
calls that return booleans, but must be made), you should also use the Or
operator.

--
HTH,

Kevin Spencer
Microsoft MVP
.Net Developer
Neither a follower nor a lender be.

"Karl Seguin" <karl REMOVE @ REMOVE openmymind REMOVEMETOO . ANDME net>
wrote in message news:%2****************@TK2MSFTNGP12.phx.gbl...

> Actually, it's an OrElse as it's short-circuit
>
> You should always be using OrElse when doing logical comparisons
> instead
> of
> Or...or should only be used as a bit operator..
>
> Karl
>
> --
> MY ASP.Net tutorials
> http://www.openmymind.net/
>
>
> "Ken Cox [Microsoft MVP]" <BA************@sympatico.ca> wrote in
> message
> news:Oe**************@tk2msftngp13.phx.gbl...
>> Looks like a logical OR to me...
>>
>> Dim Result As Boolean = (aDataset Is Nothing) Or
>> (aDataset.Tables.Count = > 0)
>>
>> Sets Result to true if aDataset is Nothing or if there are zero tables in >> aDataset
>> Sets Result to false if aDataset has been initialized or if it has at
> least
>> one table.
>>
>> "hansiman" <ha***@hotmail.com> wrote in message
>> news:7k********************************@4ax.com...
>> > on http://www.bsdg.org/2005/01/empty-dataset.shtml
>> > I came across this C# code:
>> >
>> > bool Result = ( aDataset == null ) || ( aDataset.Tables.Count ==
>> > 0 );
>> >
>> > I think I know what it is supposed to do!
>> > How is this coded in VB
>> >
>>
>
>

[Kevin Spencer]

Well, heck guys, I only said that you could. Just covering all the bases.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Neither a follower nor a lender be.

"Karl Seguin" <karl REMOVE @ REMOVE openmymind REMOVEMETOO . ANDME net>
wrote in message news:uM**************@TK2MSFTNGP12.phx.gbl...

Kevin:
My personal opinion is that this leads to
hard-to-read-gonna-cause-problems-down-the-road code. Far better to nest
the if statement in those rare instances. But ur right..it could be used
for that.

Karl
--
MY ASP.Net tutorials
http://www.openmymind.net/
"Kevin Spencer" <ke***@DIESPAMMERSDIEtakempis.com> wrote in message
news:uH*************@TK2MSFTNGP12.phx.gbl...

Well, there IS one other exception to that rule, Karl. If you have a
specific reason for needing to evaluate BOTH experssions (such as
function
calls that return booleans, but must be made), you should also use the Or
operator.

--
HTH,

Kevin Spencer
Microsoft MVP
.Net Developer
Neither a follower nor a lender be.

"Karl Seguin" <karl REMOVE @ REMOVE openmymind REMOVEMETOO . ANDME net>
wrote in message news:%2****************@TK2MSFTNGP12.phx.gbl...

> Actually, it's an OrElse as it's short-circuit
>
> You should always be using OrElse when doing logical comparisons
> instead
> of
> Or...or should only be used as a bit operator..
>
> Karl
>
> --
> MY ASP.Net tutorials
> http://www.openmymind.net/
>
>
> "Ken Cox [Microsoft MVP]" <BA************@sympatico.ca> wrote in
> message
> news:Oe**************@tk2msftngp13.phx.gbl...
>> Looks like a logical OR to me...
>>
>> Dim Result As Boolean = (aDataset Is Nothing) Or
>> (aDataset.Tables.Count = > 0)
>>
>> Sets Result to true if aDataset is Nothing or if there are zero tables in >> aDataset
>> Sets Result to false if aDataset has been initialized or if it has at
> least
>> one table.
>>
>> "hansiman" <ha***@hotmail.com> wrote in message
>> news:7k********************************@4ax.com...
>> > on http://www.bsdg.org/2005/01/empty-dataset.shtml
>> > I came across this C# code:
>> >
>> > bool Result = ( aDataset == null ) || ( aDataset.Tables.Count ==
>> > 0 );
>> >
>> > I think I know what it is supposed to do!
>> > How is this coded in VB
>> >
>>
>
>

[Steve C. Orr [MVP, MCSD]]

Don't worry Kevin, we weren't ganging up on you!
We agree with you. We just didn't want folks to go thinking it was a good
idea to go with that kind of design. But you probably already knew that.

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://SteveOrr.net
"Kevin Spencer" <ke***@DIESPAMMERSDIEtakempis.com> wrote in message
news:eR*************@TK2MSFTNGP15.phx.gbl...

Well, heck guys, I only said that you could. Just covering all the bases.

--
HTH,

Kevin Spencer
Microsoft MVP
.Net Developer
Neither a follower nor a lender be.

"Karl Seguin" <karl REMOVE @ REMOVE openmymind REMOVEMETOO . ANDME net>
wrote in message news:uM**************@TK2MSFTNGP12.phx.gbl...

Kevin:
My personal opinion is that this leads to
hard-to-read-gonna-cause-problems-down-the-road code. Far better to nest
the if statement in those rare instances. But ur right..it could be used
for that.

Karl
--
MY ASP.Net tutorials
http://www.openmymind.net/
"Kevin Spencer" <ke***@DIESPAMMERSDIEtakempis.com> wrote in message
news:uH*************@TK2MSFTNGP12.phx.gbl...

Well, there IS one other exception to that rule, Karl. If you have a
specific reason for needing to evaluate BOTH experssions (such as
function
calls that return booleans, but must be made), you should also use the
Or
operator.

--
HTH,

Kevin Spencer
Microsoft MVP
.Net Developer
Neither a follower nor a lender be.

"Karl Seguin" <karl REMOVE @ REMOVE openmymind REMOVEMETOO . ANDME net>
wrote in message news:%2****************@TK2MSFTNGP12.phx.gbl...
> Actually, it's an OrElse as it's short-circuit
>
> You should always be using OrElse when doing logical comparisons
> instead
> of
> Or...or should only be used as a bit operator..
>
> Karl
>
> --
> MY ASP.Net tutorials
> http://www.openmymind.net/
>
>
> "Ken Cox [Microsoft MVP]" <BA************@sympatico.ca> wrote in
> message
> news:Oe**************@tk2msftngp13.phx.gbl...
>> Looks like a logical OR to me...
>>
>> Dim Result As Boolean = (aDataset Is Nothing) Or
>> (aDataset.Tables.Count

=

> 0)
>>
>> Sets Result to true if aDataset is Nothing or if there are zero
>> tables

in

>> aDataset
>> Sets Result to false if aDataset has been initialized or if it has at
> least
>> one table.
>>
>> "hansiman" <ha***@hotmail.com> wrote in message
>> news:7k********************************@4ax.com...
>> > on http://www.bsdg.org/2005/01/empty-dataset.shtml
>> > I came across this C# code:
>> >
>> > bool Result = ( aDataset == null ) || ( aDataset.Tables.Count ==
>> > 0 );
>> >
>> > I think I know what it is supposed to do!
>> > How is this coded in VB
>> >
>>
>
>

[Kevin Spencer]

I understand, Steve. :)

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Neither a follower nor a lender be.

"Steve C. Orr [MVP, MCSD]" <St***@Orr.net> wrote in message
news:ub**************@tk2msftngp13.phx.gbl...

Don't worry Kevin, we weren't ganging up on you!
We agree with you. We just didn't want folks to go thinking it was a good
idea to go with that kind of design. But you probably already knew that.

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://SteveOrr.net
"Kevin Spencer" <ke***@DIESPAMMERSDIEtakempis.com> wrote in message
news:eR*************@TK2MSFTNGP15.phx.gbl...

Well, heck guys, I only said that you could. Just covering all the bases.

--
HTH,

Kevin Spencer
Microsoft MVP
.Net Developer
Neither a follower nor a lender be.

"Karl Seguin" <karl REMOVE @ REMOVE openmymind REMOVEMETOO . ANDME net>
wrote in message news:uM**************@TK2MSFTNGP12.phx.gbl...

Kevin:
My personal opinion is that this leads to
hard-to-read-gonna-cause-problems-down-the-road code. Far better to
nest
the if statement in those rare instances. But ur right..it could be
used
for that.

Karl
--
MY ASP.Net tutorials
http://www.openmymind.net/
"Kevin Spencer" <ke***@DIESPAMMERSDIEtakempis.com> wrote in message
news:uH*************@TK2MSFTNGP12.phx.gbl...
Well, there IS one other exception to that rule, Karl. If you have a
specific reason for needing to evaluate BOTH experssions (such as
function
calls that return booleans, but must be made), you should also use the
Or
operator.

--
HTH,

Kevin Spencer
Microsoft MVP
.Net Developer
Neither a follower nor a lender be.

"Karl Seguin" <karl REMOVE @ REMOVE openmymind REMOVEMETOO . ANDME net>
wrote in message news:%2****************@TK2MSFTNGP12.phx.gbl...
> Actually, it's an OrElse as it's short-circuit
>
> You should always be using OrElse when doing logical comparisons
> instead
> of
> Or...or should only be used as a bit operator..
>
> Karl
>
> --
> MY ASP.Net tutorials
> http://www.openmymind.net/
>
>
> "Ken Cox [Microsoft MVP]" <BA************@sympatico.ca> wrote in
> message
> news:Oe**************@tk2msftngp13.phx.gbl...
>> Looks like a logical OR to me...
>>
>> Dim Result As Boolean = (aDataset Is Nothing) Or
>> (aDataset.Tables.Count
=
> 0)
>>
>> Sets Result to true if aDataset is Nothing or if there are zero
>> tables
in
>> aDataset
>> Sets Result to false if aDataset has been initialized or if it has
>> at
> least
>> one table.
>>
>> "hansiman" <ha***@hotmail.com> wrote in message
>> news:7k********************************@4ax.com...
>> > on http://www.bsdg.org/2005/01/empty-dataset.shtml
>> > I came across this C# code:
>> >
>> > bool Result = ( aDataset == null ) || ( aDataset.Tables.Count ==
>> > 0 );
>> >
>> > I think I know what it is supposed to do!
>> > How is this coded in VB
>> >
>>
>
>