[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

Solved

vb.net using and or andalso

Posted on 2013-10-29

1 solution

Medium Priority

237 Views

Last Modified: 2013-10-29

Hello,
I would like to know what are the options of using And or AndAlso to get the same results that I have here..

    Private Sub Button1_Click_1(sender As Object, e As EventArgs) Handles Button1.Click
        If MyIPAddress = "0" Then
            If MyIPAddress = OldIPAddress Then
                If MyIPAddress.StartsWith("168.") Then
                    If MyIPAddress.StartsWith("169.") Then
                        If MyIPAddress.StartsWith("192.") Then

                                Debug.Print("all good")

                        End If
                    End If
                End If
            End If
        End If
    End Sub

Open in new window

Comment

Question by:XK8ER

[X]

Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

Help others & share knowledge
Earn cash & points
Learn & ask questions

Join The Community

4 Comments

LVL 42

Expert Comment

by:Meir Rivkin

ID: 396085132013-10-29

here:

    Private Sub Button1_Click_1(sender As Object, e As EventArgs) Handles Button1.Click
        If MyIPAddress = "0" AndAlso 
MyIPAddress = OldIPAddress AndAlso  
MyIPAddress.StartsWith("168.") AndAlso 
MyIPAddress.StartsWith("169.") AndAlso 
MyIPAddress.StartsWith("192.") Then
                                Debug.Print("all good")

                        End If
                    End If
                End If
            End If
        End If
    End Sub

Open in new window

LVL 75

Accepted Solution

by:käµfm³d 👽

käµfm³d 👽 earned 2000 total points

ID: 396085212013-10-29

Private Sub Button1_Click_1(sender As Object, e As EventArgs) Handles Button1.Click
    If MyIPAddress = "0" AndAlso _
       MyIPAddress = OldIPAddress AndAlso _
       MyIPAddress.StartsWith("168.") AndAlso _
       MyIPAddress.StartsWith("169.") AndAlso _
       MyIPAddress.StartsWith("192.") Then
        Debug.Print("all good")
    End If
End Sub

Open in new window

And would do the same thing, except that And would evaluate *every* condition, whereas AndAlso will "short-circuit" on the first non-true condition. If any condition is False, then there is no reason to check the remaining conditions. In boolean algebra, in order for a boolean and to result in true, every condition must be true. If any single condition is false, then the overall result will be false. This is what "short-circuiting" accomplishes.

LVL 8

Expert Comment

by:5teveo

ID: 396085382013-10-29

Not sure logic above makes sense...
If MyIPAddress = "0" then address can not be another value to test inside If block...

Maybe...

Private Sub Button1_Click_1(sender As Object, e As EventArgs) Handles Button1.Click
If MyIPAddress <> "0" Then
If MyIPAddress <> OldIPAddress Then
If MyIPAddress.StartsWith("168.") OR _
MyIPAddress.StartsWith("169.") OR _
MyIPAddress.StartsWith("192.") Then
Debug.Print("all good")
End If
End If
End If
End Sub

LVL 70

Expert Comment

by:Éric Moreau

ID: 396093582013-10-29

you should not use or/and (but prefer orelse/andalso).

the explanation is at http://emoreau.com/Entries/Articles/2008/04/Short-circuiting-mainly-in-VBNet-and-SQL-Server.aspx

Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Parsing a CSV file into a datatable using LINQ and Regex

Article by: nepaluz

Parsing a CSV file is a task that we are confronted with regularly, and although there are a vast number of means to do this, as a newbie, the field can be confusing and the tools can seem complex. A simple solution to parsing a customized CSV fi…

Visual Basic.NET

VB .NET Retrieving FX Rates from ECB site and parsing XML into a datatable

Article by: nepaluz

The ECB site provides FX rates for major currencies since its inception in 1999 in the form of an XML feed. The files have the following format (reducted for brevity) (CODE) There are three files available HERE (http://www.ecb.europa.eu/stats/exch…

Visual Basic.NET

[Webinar] How Hackers Steal Your Credentials and Why Active Directory Must be Secure to Stop Them

Video by: Experts Exchange

Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…

Why Use Three Nodes in a Database Cluster?

Video by: Percona

In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…