how to optimize an if condition for multiple values of same variable in vb

Question

How to write an If Condition having a single variable but multiple values.

Ex : 'Consider I have employee details filled in a data table

If (dt.Rows(0).Items("Id").ToString() = "548" Or dt.Rows(0).Items("Id").ToString() = "78787" Or dt.Rows(0).Items("Id").ToString() = "787" Or dt.Rows(0).Items("Id").ToString() = "11" Or dt.Rows(0).Items("Id").ToString() = "025" Or dt.Rows(0).Items("Id").ToString() = "568") Then
MessageBox.Show("INSIDE")
End if

How can I optimize this If condition?

What data type is the Id column? I would guess Integer. In that case, one thing you could do is treat the values as Integers. NEVER convert data that is not text to Strings unless you have to. In this case, CInt(dt.Rows(0)("Id")) = 548 or dt.Rows(0).Field(Of Integer)("Id") = 548 would be a start. — jmcilhinney
– jmcilhinney, Commented May 17, 2021 at 0:18

Charlieface · Accepted Answer · 2021-05-16 15:24:16Z

1

You can use a Select statement with multiple items in one case:

Select dt.Rows(0).Items("Id").ToString()
Case "548", "78787", "787", "11", "025", "568"
    MessageBox.Show("INSIDE")
End Select

answered May 16, 2021 at 15:24

Charlieface

78.7k8 gold badges35 silver badges77 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

how to optimize an if condition for multiple values of same variable in vb

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related